CODEWITHSUNDEEP
apache-sparkpysparkazure-databricksdelta-lake
Patterson
Patterson

Reputation: 2821

How to create a table in databricks from an existing table on SQL

Can someone let me know how to create a table in Azure Databricks from a table that exists on Azure sql server? (assuming Databricks already has a jdbc connection to the sql server).

For example, the following will create a table if it doesn't exist from a location in my datalake.

CREATE TABLE IF NOT EXISTS newDB.MyTable USING delta LOCATION
'/mnt/dblake/BASE/Public/Adventureworks/delta/SalesLT.Product/'

I would like do the same but with the table existing on SQL Server?

Upvotes: 5

Views: 7280

Answers (1)

David דודו Markovitz
David דודו Markovitz

Reputation: 44991

Here is the basic solution for creation of an external table over an Azure SQL table
You can take the url (connection string) from the Azure Portal

create table if not exists mydb.mytable
using jdbc
options (url = 'jdbc:sqlserver://mysqlserver.database.windows.net:1433;database=mydb;user=myuser;password=mypassword;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;', dbtable = 'dbo.mytable')

Check the following links for additional options

https://spark.apache.org/docs/latest/sql-ref-syntax-ddl-create-table-datasource.html https://spark.apache.org/docs/latest/sql-data-sources-jdbc.html

Upvotes: 2

Related Questions