- 424 Views
- 1 replies
- 0 kudos
Does Koalas support Structured Streaming
- 424 Views
- 1 replies
- 0 kudos
Latest Reply
No, Koalas does not support Structured Streaming officially.As a workaround, you can use Koalas APIs with foreachBatch in Structured Streaming which allows batch APIs:>>> def func(batch_df, batch_id):
... koalas_df = ks.DataFrame(batch_df)
.....
- 717 Views
- 1 replies
- 0 kudos
How do i connect DBSQL to other BI tools?
- 717 Views
- 1 replies
- 0 kudos
Latest Reply
Generally, you can connect to SQL endpoint using a ODBC or JDBC driver. More information can be found here. https://docs.databricks.com/integrations/bi/index-sqla.html
- 2881 Views
- 1 replies
- 0 kudos
I'd like to be able to limit the rows users see when querying tables in Databricks SQL based on what access level each user is supposed to be granted. Is this possible in the SQL environment?
- 2881 Views
- 1 replies
- 0 kudos
Latest Reply
Using dynamic views you can specify permissions down to the row or field level e.g. CREATE VIEW sales_redacted AS
SELECT
user_id,
country,
product,
total
FROM sales_raw
WHERE
CASE
WHEN is_member('managers') THEN TRUE
ELSE total <= 1...
- 731 Views
- 1 replies
- 0 kudos
I see the option to enable Photon when creating a new SQL Endpoint. The description says that enabling it helps speed up up queries, which sounds good, but are there any downsides I need to be aware of?
- 731 Views
- 1 replies
- 0 kudos
Latest Reply
Generally, yes you should enable photon. The majority of functionality is available and will perform extremely well. There are some limitations with it that can be found here. Limitations: Works on Delta and Parquet tables only for both read and writ...
- 967 Views
- 1 replies
- 0 kudos
If I want to get more information about how an individual query is performing in the Databricks SQL environment, is there anywhere I can see that?
- 967 Views
- 1 replies
- 0 kudos
Latest Reply
You could see details on different queries that ran against an endpoint under the query history section
- 4259 Views
- 1 replies
- 0 kudos
Need to know if I can use job clusters to start and run streaming jobs or if it has to be interactive
- 4259 Views
- 1 replies
- 0 kudos
Latest Reply
Yes. Here is a doc containing some info on running Structured Streaming in production using Databricks jobs
- 447 Views
- 1 replies
- 0 kudos
How to troubleshoot SSL certificate errors while connecting Business Intelligence (BI) tools to Databricks in a Private Cloud (PVC) environment?
- 447 Views
- 1 replies
- 0 kudos
Latest Reply
See attached for steps to inspect the certificate chain using openssl
- 1500 Views
- 1 replies
- 1 kudos
While trying to read 100GB of csv.gz file from Spark which is taking forever to read, what are best options to read this file faster?
- 1500 Views
- 1 replies
- 1 kudos
Latest Reply
Part of the problem here is that .gz files are not splittable. If you have 1 huge 100GB .gz file, it can only be processed by one task. Can you change your input to use a splittable compression like .bz2? it'll work much better.
- 3658 Views
- 1 replies
- 0 kudos
SQL Workbench is not able to connect to Cluster using JDBC/ODBC connection. Getting the following error. I used the configuration provided by the cluster (jdbc:spark://<host>.cloud.databricks.com:443/default;transportMode=http;ssl=1;httpPath=sql/prot...
- 3658 Views
- 1 replies
- 0 kudos
Latest Reply
As we are getting 401 error that means an authentication issue. We should use Personal access token for password.The username should be "token" and the password should be PAT token.