CODEWITHSUNDEEP
apache-sparkpysparkazure-databricksdelta-lake
Patterson
Patterson

Reputation: 2757

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: 7182

Answers (1)

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

Reputation: 44911

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