Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 10 views

    SMEW Lab 8A Tahoe

    Uploaded by

    Dhruv Patel
    Lottie created an ACME_DETROIT database share to store inventory data in Snowflake. The share includes a table to store inventory records, a view to break down vehicle identification numbers, and an outbound share configured for listing the data without any consumers added yet. Optional code and data files are provided to help understand and replicate the database design.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    SMEW Lab 8A Tahoe

    Uploaded by

    Dhruv Patel
    10 views5 pages
    Lottie created an ACME_DETROIT database share to store inventory data in Snowflake. The share includes a table to store inventory records, a view to break down vehicle identification numbers, and an outbound share configured for listing the data without any consumers added yet. Optional code and data files are provided to help understand and replicate the database design.

    Original Description:

    Original Title

    SMEW-Lab-8A-Tahoe

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Lottie created an ACME_DETROIT database share to store inventory data in Snowflake. The share includes a table to store inventory records, a view to break down vehicle identification numbers, and an outbound share configured for listing the data without any consumers added yet. Optional code and data files are provided to help understand and replicate the database design.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    10 views5 pages

    SMEW Lab 8A Tahoe

    Uploaded by

    Dhruv Patel
    Lottie created an ACME_DETROIT database share to store inventory data in Snowflake. The share includes a table to store inventory records, a view to break down vehicle identification numbers, and an outbound share configured for listing the data without any consumers added yet. Optional code and data files are provided to help understand and replicate the database design.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 5

    © 2020 Snowflake Computing Inc.

    All Rights Reserved


    ACME-ADU Exchange Design SQL Object Definition Code
    Lottie’s ACME_DETROIT Share
    Object Definition Code Object Data Preview ERD Entity View

    Lottie enters her new


    inventory into this
    table.

    This view breaks the


    VIN into component
    parts like WMI, VDS,
    Model Year and Plant
    Code.

    © 2020 Snowflake Computing Inc. All Rights Reserved


    ACME-ADU Exchange Design SQL Object Definition Code
    Lottie’s ACME_DETROIT Share
    Outbound Share created as foundation for listing.

    When creating the outbound


    share for the listing, do not add
    consumers.

    © 2020 Snowflake Computing Inc. All Rights Reserved


    ACME-ADU Exchange Design SQL Object Definition Code
    Lottie’s ACME_DETROIT Share
    Outbound Share created as foundation for listing.

    This value gets filled in when you set up your listing in the Exchange.

    If this field has a direct share account listed as a Consumer, it cannot be


    used in an exchange.
    © 2020 Snowflake Computing Inc. All Rights Reserved
    ACME-ADU Exchange Design
    Lottie’s ACME_DETROIT Share
    Code and Data Files

    OPTIONAL

    Download and run


    the code to create the
    schemas, table, view,
    and share for Lottie’s
    share.

    Do this only if you


    think it will help you
    understand the
    design better.

    © 2020 Snowflake Computing Inc. All Rights Reserved

    You might also like