- 1158 Views
- 2 replies
- 3 kudos
Lakehouse Fundamentals Course
I have an issue I encountered while attempting to access the Lakehouse Fundamentals badge quiz. Every time I try to access the quiz, I receive the following error message: "Access denied. You do not have permission to access this page. Please contact...
- 1158 Views
- 2 replies
- 3 kudos
- 3 kudos
If this does not help you can reach out to training-ops@databricks.com
- 3 kudos
- 1415 Views
- 2 replies
- 2 kudos
Resolved! Wap pattern unity catalog
Good afternoon,I am looking for documentation to implement the WAP pattern using Unity Catalog, workflows, SQL notebooks, and any other services necessary to use this pattern. Could you share information on how to approach the problem with documentat...
- 1415 Views
- 2 replies
- 2 kudos
- 2 kudos
Hi @jorperort ,Apart from nice step by step instruction that @VZLA has provided, you can also take a look at short presentation of WAP pattern at the official databricks YT channel:https://youtu.be/4K3zAmUgViE?t=492
- 2 kudos
- 1892 Views
- 8 replies
- 1 kudos
Is it possible to load data only using Databricks SDK?
Is it possible to load data only using Databricks SDK?I have custom library that has to load data to a table, and I know about other features like autoloader, COPY INTO, notebook with spark dataframe... but I wonder if it is possible to load data dir...
- 1892 Views
- 8 replies
- 1 kudos
- 1 kudos
Got it, the reason of the cluster is because with shared access cluster the access to local system is more restricted that with single user cluster due to security constraints. As you are using serverless it acts as a shared cluster, on this case you...
- 1 kudos
- 739 Views
- 2 replies
- 0 kudos
Submit new records from gold layer to postgres db
Hi community,I want to ask you which is the best practice in your opinion to fill the data from gold layer to postgres db that is used to provide "real-time" data to an UI interface?Thanks for any help!
- 739 Views
- 2 replies
- 0 kudos
- 0 kudos
Hello @hari-prasad, Thanks you for your answer, considers that we are using DLT Pipelines, is it a good choice in this case? Because actually I don't see with DLT Pipelines the metadata for these materialized tables in this case these CDF statements
- 0 kudos
- 5336 Views
- 1 replies
- 0 kudos
Refresh options on PBI from Databricks workflow using Azure Databricks
Hi!I have a workflow that includes my medallion architecture and DLT. Currently, I have a separate notebook for refreshing my Power BI semantic model, which works based on the method described in Refresh a PowerBI dataset from Azure Databricks. Howe...
- 5336 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @mkEngineer, Have you reviewed this documentation: https://learn.microsoft.com/en-us/azure/databricks/partners/bi/power-bi Also I don't think Serverless compute for Notebook will work for your connection with Power BI. You might need to setup a Se...
- 0 kudos
- 57419 Views
- 7 replies
- 13 kudos
How to connect and extract data from sharepoint using Databricks (AWS) ?
We are using Databricks (on AWS). We need to connect to SharePoint and extract & load data to Databricks Delta table. Any possible solution on this ?
- 57419 Views
- 7 replies
- 13 kudos
- 13 kudos
Wondering the same.. Can we use Sharepoint REST API to download the file and save to dbfs/external location and read it?
- 13 kudos
- 713 Views
- 1 replies
- 1 kudos
Access the data from cross-cloud.
Hi All ,We have a use case where we need to connect AWS Databricks to a GCP storage bucket to access the data. In Databricks We're trying to use external locations and storage credentials, but it seems like AWS Databricks only supports AWS storage b...
- 713 Views
- 1 replies
- 1 kudos
- 1 kudos
Hi @Phani1 ,You can use delta sharing. In that way you can create share that will allow you to access data stored in GCS and it's govern by UC permissions model.What is Delta Sharing? | Databricks on AWSYou can also use legacy approach, but it doesn'...
- 1 kudos
- 2574 Views
- 1 replies
- 2 kudos
Resolved! Azure Databricks quota restrictions on compute in Azure for students subscription
Hi All,Regrading creating clusters in Databricks I'm getting quota error have tried to increase quotas in the region where the resource is hosted still unable to increase the limit, is there any workaround or could you help select the right cluster ...
- 2574 Views
- 1 replies
- 2 kudos
- 2 kudos
Hi @svm_varma ,You can try to create Standard_DS3_v2 cluster. It has 4 cores and your current subscription limit for given region is 6 cores. The one you're trying to create needs 8 cores and hence you're getting quota exceeded exception.You can also...
- 2 kudos
- 1856 Views
- 9 replies
- 0 kudos
databricks job taking longer time to load 2.3 gb data from bolb to ssms table
df_CorpBond= spark.read.format("parquet").option("header", "true").load(f"/mnt/{container_name}/raw_data/dsl.corporate.parquet") df_CorpBond.repartition(20).write\ .format("jdbc")\ .option("url", url_connector)\ .option("dbtable", "MarkIt...
- 1856 Views
- 9 replies
- 0 kudos
- 0 kudos
Hi @RiyazAliM this is my dag digramfile size is 3.5 gb and in future we need to load 14gb as well
- 0 kudos
- 1172 Views
- 0 replies
- 0 kudos
Dataiku and Databricks a promising future to democratize AI.
Democratize Data and AI is the prime focus of organization in 2025. With this some of the products that are going to fly with their offerings are Dataiku and Databricks.Please check my article on this:https://medium.com/@infinitylearnings1201/databri...
- 1172 Views
- 0 replies
- 0 kudos
- 3830 Views
- 1 replies
- 1 kudos
Apache Spark SQL query to get organization hierarchy
I'm currently diving deep into Spark SQL and its capabilities, and I'm facing an interesting challenge. I'm eager to learn how to write CTE recursive queries in Spark SQL, but after thorough research, it seems that Spark doesn't natively support recu...
- 3830 Views
- 1 replies
- 1 kudos
- 1 kudos
Hi @singhanuj2803, It is correct that Spark SQL does not natively support recursive Common Table Expressions (CTEs). However, there are some workarounds and alternative methods you can use to achieve similar results. Using DataFrame API with Loops:...
- 1 kudos
- 930 Views
- 1 replies
- 1 kudos
How to run stored procedure in Azure Database for PostgreSQL using Azure Databricks Notebook
We have Stored Procedure available in Azure Database for PostgreSQL and we want to call or run or execute the postgreSQL stored procedures in Azure Databricks through NotebookWe are attempting to run PostgreSQL stored procedures, through Azure Databr...
- 930 Views
- 1 replies
- 1 kudos
- 1 kudos
To execute a PostgreSQL stored procedure from an Azure Databricks notebook, you need to follow these steps: Required Libraries:You need to install the psycopg2 library, which is a PostgreSQL adapter for Python. This can be done using the %pip install...
- 1 kudos
- 3251 Views
- 1 replies
- 0 kudos
Resolved! How to execute SQL stored procedure in Azure Database for SQL Server using Azure Databricks Notebook
We have Stored Procedure available in Azure Database for SQL Server and we want to call or run or execute the postgreSQL stored procedures in Azure Databricks through NotebookWe are attempting to run SQL stored procedures, through Azure Databricks no...
- 3251 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @singhanuj2803, To execute a SQL stored procedure in Azure Databricks, you can follow these steps: Required Libraries:You need to install the pyodbc library to connect to Azure SQL Database using ODBC. You can install it using the following comman...
- 0 kudos
- 4168 Views
- 3 replies
- 3 kudos
Resolved! Deleting records from Delta table that are not in relational table
I have a Delta table that I keep in sync with a relational (SQL Server) table. The inserts and updates are easy but checking for records to delete is prohibitively slow. I am querying the relational table for all primary key values and any primary ke...
- 4168 Views
- 3 replies
- 3 kudos
- 3 kudos
Let's understand the complexity behind this code when executed on delta table along with Spark.pks = spark.read.format("jdbc").option("query": "SELECT pk FROM sql_table_name").load() delta_table = spark.read.table(delta_table_name) r = target_table.f...
- 3 kudos
- 3947 Views
- 9 replies
- 5 kudos
Resolved! Magic Commands (%sql) Not Working with Databricks Extension for VS Code
Hi Community,I’ve encountered an issue with the Databricks Extension for VS Code that seems to contradict the documentation. According to the Databricks documentation, the extension supports magic commands like %sql when used with Databricks Connect:...
- 3947 Views
- 9 replies
- 5 kudos
- 5 kudos
In reality, there is nothing to do with grpc_wait_for_shutdown_with_timeout. Although we haven't yet implemented a solution, we have an open issue for it, but it shouldn't stop SQL magic from working.Or is the "Interactive" tab where you encounter th...
- 5 kudos
| User | Count |
|---|---|
| 1619 | |
| 790 | |
| 489 | |
| 349 | |
| 287 |
