cancel
Showing results for 
Search instead for 
Did you mean: 
Administration & Architecture
Explore discussions on Databricks administration, deployment strategies, and architectural best practices. Connect with administrators and architects to optimize your Databricks environment for performance, scalability, and security.
cancel
Showing results for 
Search instead for 
Did you mean: 

Delta Live Table tables in Data Tab

KKo
Contributor III

If I use this code (CREATE STREAMING LIVE TABLE Employee) in dlt pipeline, where does the Employee table gets created by default, if no storage location is specified? How can I create this table in Data tab within a database (a.k.a: Schema) lets say dim so that I can use it for reporting or any other purpose? Thanks in advance!

1 REPLY 1

Anonymous
Not applicable

@Kris Koirala​ :

When you create a streaming live table in Databricks Delta Lake using the code CREATE STREAMING LIVE TABLE Employee, the table is created in the default database called default. If no storage location is specified, the table is stored in the default Delta Lake file system associated with your Databricks workspace. To create the table in a specific database (schema) such as dim, you can use the following syntax:

CREATE STREAMING LIVE TABLE dim.Employee

This statement creates the Employee table within the dim database. The table will be available in the Data tab of your Databricks workspace under the specified database. You can then use this table for reporting or any other purposes within your Databricks environment.

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!