How can I access the feature store tables in Azure Storage Explorer? What is the default storage location for delta lake tables ?

pdub 21 Reputation points
2021-07-12T17:15:28.63+00:00

I am using the Feature Store taxi example notebook for creating a feature store in DBR 8.3 ML. I am able to generate the feature tables and view details in the Feature Store menu. However I am not sure what is the default location where these are getting generated. I would like to view these delta tables in the Azure Storage Explorer. Can anyone please guide me?

113870-image.png

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,001 questions
0 comments No comments
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 81,151 Reputation points Microsoft Employee
    2021-07-13T04:13:33.747+00:00

    Hello @pdub ,

    Thanks for the question and using MS Q&A platform.

    Unfortunately, you cannot access the feature store tables in Azure Storage Explorer.

    You can use the below methods to access the feature store tables:

    Note: Feature tables are stored as Delta tables.

    Method1: The Databricks Feature Store UI shows the name of the table and database in the online store, along with other metadata.

    114057-image.png

    Method2: You can view this tables from the Data section => Database Tables.

    ![114064-image.png][3]

    Method3: You can view this tables from DBFS file browser.

    DBFS => Users => Hive => warehouse => select database => select table

    114000-adb-featurestore-dbfs.gif

    Method4: Using DBFS Explorer for Databricks

    114047-image.png

    Hope this helps. Do let us know if you any further queries.


    Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful