Your Browser is Out of Date

Nytro.ai uses technology that works best in other browsers.
For a full experience use one of the browsers below
Simplify Data Access and Accelerate Insights with Dell ECS and Snowflake
Executive summary Architecture General limitations Getting started Additional examples
Directory table
Materialized view
Unload data
Best practices References

Directory table

Home > Storage > ObjectScale and ECS > Industry Solutions and Verticals > Simplify Data Access and Accelerate Insights with Dell ECS and Snowflake > Directory table

Directory table

  • A directory table, typically used to provide Snowflake access to unstructured datafiles, can be added to any external stage that you create. You can query the directory table to retrieve file URLs to access files in the referenced storage, as well as other metadata.

    create or replace stage ext_stage_dellecs

    url='s3compat://snowflake/dellecs/iris/'

    endpoint='<Dell ECS On-Prem endpoint>'

      credentials=(

        AWS_KEY_ID='<Dell ECS Access key>'

        AWS_SECRET_KEY='<Dell ECS Secret Key>'

      )

      directory=(

        Enable=true

      );