Databricks

vanessafvg · 08-15-2023

I know this has probably been asked many times, although I have struggled to find the answer using sql CREATE STREAMING LIVE TABLE bronze_site_usage COMMENT "ingest latest snapshot from api"TBLPROPERTIES ("layer" = "bronze") AS SELECT * FROM cloud_fi...

vanessafvg · 06-15-2023

i am trying to extract some data into databricks but tripping all over openpyxl, newish user of databricks..from openpyxl import load_workbookdirectory_id="hidden"scope="hidden"client_id="hidden"service_credential_key="hidden"container_name="hidden"s...

vanessafvg · 10-01-2022

I am having to use Databricks SQL dashboard for some analysis, it seems very clunky. If i have multiple queries, is it possible to apply the same filters to all the queries in the dashboard or do i have to duplicate the filters for each query in the ...

vanessafvg · 09-30-2022

I want to remove one of these filters but there doesn't seem to be a way to do it.

vanessafvg · 09-30-2022

ah Sorry @Hubert Dudek I should have updated this thread, I realised what had happened and the filter was on top of the script so i just removed it. Bit of a newbie error! thanks for responding.

Databricks

User Stats

User Activity

Using SQL to create delta live tables but column headers from csv have spaces

Extracting data from excel in datalake storage using openpyxl

linking filters from different Databricks SQL queries in a Dashboard

How do I remove a filter from the visualisations pane in databricks sql, 2 i am able to remove but for some reason the Year filter doesn't have a delete option? The documentation isn't very comprehensive.

Re: How do I remove a filter from the visualisations pane in databricks sql, 2 i am able to remove but for some reason the Year filter doesn't have a delete option? The documentation isn't very comprehensive.