cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Help
Data Engineering
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Start a conversation
Sudeshna
by • New Contributor III
  • 8481 Views
  • 7 replies
  • 8 kudos

Resolved! I am new to Databricks SQL and want to create a variable which can hold calculations either from static values or from select queries similar to SQL Server. Is there a way to do so?

I was trying to create a variable and i got the following error -command - SET a = 5;Error -Error running queryConfiguration a is not available.

Data Engineering
Reply
  • 8481 Views
  • 7 replies
  • 8 kudos
View Replies
Latest Reply
BilalAslamDbrx
Honored Contributor II
  • 8 kudos

@Sudeshna Bhakat​ what @Joseph Kambourakis​ described works on clusters but is restricted on Databricks SQL endpoints i.e. only a limited number of SET commands are allowed. I suggest you explore the curly-braces (e.g. {{ my_variable }}) in Databrick...

  • 8 kudos
6 More Replies
wyzer
by • Contributor II
  • 2175 Views
  • 2 replies
  • 2 kudos

Resolved! Insert data into an on-premise SQL Server

Hello,Is it possible to insert data from Databricks into an on-premise SQL Server ?Thanks.

Data Engineering
Reply
  • 2175 Views
  • 2 replies
  • 2 kudos
View Replies
Latest Reply
wyzer
Contributor II
  • 2 kudos

Hello,Yes we find out how to do it by installing a JDBC connector.It works fine.Thanks.

  • 2 kudos
1 More Replies
tarente
by • New Contributor III
  • 5811 Views
  • 9 replies
  • 4 kudos

Resolved! Pyspark - how to save the schema of a csv file in a delta table's column

How to save the schema of a csv file in a delta table's column?In a previous project implemented in Databricks using Scala notebooks, we stored the schema of csv files as a "json string" in a SQL Server table.When we needed to read or write the csv a...

Data Engineering
Reply
  • 5811 Views
  • 9 replies
  • 4 kudos
View Replies
Latest Reply
Anonymous
Not applicable
  • 4 kudos

@tarente - Thanks for letting us know.

  • 4 kudos
8 More Replies
Labels