Databricks Community

WWoman · 06-18-2024

Hello,I have a user that would like to create a CSV file on their local file system by creating an external table (USING CSV) and specifying a local file for the path parameter using SQL. They will be running this command from a local client (DbVisua...

WWoman · 06-11-2024

Hi all,I am looking for description of action_name column in system.access.audit. I am specifically interested in getTable, deleteTable and createTable. I believe the latter 2 are self descriptive but I'd like to confirm.If getTable is related to acc...

WWoman · 05-28-2024

Hello all, I am running into a permission issue when running a simple MERGE INTO query from a Notebook: " AnalysisException: [INSUFFICIENT_PERMISSIONS] Insufficient privileges: User does not have USE SCHEMA on Schema 'system.query'."I can run the que...

WWoman · 05-23-2024

Hello,I am looking for a way to persist query history data. I have not have direct access to the system tables. I do have access to a query_history view created by selecting from the system.query.history and system.access.audit system tables. I want ...

WWoman · 05-23-2024

Is there a way to identify all invalid views in a schema or catalog without querying the view to see if it succeeds?

WWoman · 06-11-2024

That does sound like it makes sense, but what action(s) describes actually accessing the data in the table?

WWoman · 05-28-2024

On a related note... I am not seeing my notebook queries in the query history interface. I was trying to confirm that the queries run from the notebook would run with my user id, but I don't see these queries at all.

WWoman · 05-21-2024

I tested this and I am just seeing the groups with the API that I see with SHOW GROUPS. It is not showing all the groups that I see from the account console.

WWoman · 05-15-2024

A quick question on this... (First of all thanks so much for the sample code!). I'm playing around with this and I would like to get the statement_type and status. I see that duration, query_start_time_ms and query_end_time_ms are int data type and d...

WWoman · 03-15-2024

I would like to be able to query the query history tables by running my own queries. I do not want to use the Query History interface supplied by Databricks; I want to be able to create python scripts that access the underling tables/views for TAC a...

Databricks Community

User Stats

User Activity

Is there a way to create a local CSV file by creating a local external table?

Looking for descriptions of action_name column in system.access.audit.. specifically getTable

Insufficient privileges error when running query from Notebook

Persisting query history data

Identifying invalid views

Re: Looking for descriptions of action_name column in system.access.audit.. specifically getTable

Re: Insufficient privileges error when running query from Notebook

Re: SHOW GROUPS is not giving groups available at the account level

Re: Direct access to Databricks query history database

Re: Direct access to Databricks query history database