In Azure SQL, I'm attempting to delete any text that is present between the < and > characters to my column in my table Sample text: The best part is that. < br >Note:< br >< u> reading :< /u> <…
I have a data frame and synapse sql table ,Need to merge the data frame into a synapse table with a delta location . I followed different documents but still not able to merge in synapse Could you help me…
Cannot see all database in Azure Synapse. I have two other spark pools but i cannot see them in the regular Databases tab.
I am trying to connect to Azure Serverless SQL using python but getting the following error External table 'dbo.my_table' is not accessible because location does not exist or it is used by another process. I have created the External table…
I have a Az Synapse (dedicated SQL pool) configured with managed VNet in tenant A and storage account in tenant B. The storage account is firewall protected and only certain VNets and IPs can access it. I want to created…
I have a storage account with firewall settings enabled (restricted access from only certain IPs and VNets). I need to access this storage account from Az Dedicated SQL Pool residing inside a SQL server. For this, I am using the…
I ran into this issue below, when trying to run a simple pyspark script in Azure: %%pyspark df = spark.read.load('abfss://[email protected]/userdata1.parquet', format='parquet') display(df.limit(10)) InvalidHttpRequestToLivy: Your Spark job requested 24 vcores. However, the workspace has a 12 core limit. Try reducing the…
I am loading in .gzip files as binary to my raw container, and I am now wondering how to proceed in azure synapse analytics. I would like to get the binary .gzip and move it to a different folder and…
I'm trying to create an Azure Synapse Link for Azure SQL Database, using the steps from here: https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/connect-synapse-link-sql-database After I create the link connection and I want to start it I receive the following error: The connection to the sink…
I'd like to generate a table that consists of list of all available tables and number of rows for each of them. Table Name Number of rows SCHEMA.TABLE_NAME1 30 SCHEMA.TABLE_NAME2 40 I've used the query below: select schema_name(tab.schema_id) + '.'…