The following code assumes you have the third-party sample dataset diamonds within a schema named default within a catalog named main that is accessible from your Azure Databricks workspace. If the catalog or schema that you want to use has a different na

The following code assumes you have the third-party sample dataset diamonds within a schema named default within a catalog named main that is accessible from your Azure Databricks workspace. If the catalog or schema that you want to use has a different na

Comment

0

SELECT CASE -- If the table exists in the specified catalog and schema... WHEN table_exists("main", "default", "diamonds") THEN -- And the specified column exists in that table... (SELECT CASE WHEN column_exists("main", "default", "diamonds", "clarity") THEN -- Then report the number of rows for the specified value in that column. printf("There are %d rows in table 'main.default.diamonds' where 'clarity' equals 'VVS2'.", num_rows_for_clarity_in_diamonds("VVS2")) ELSE printf("Column 'clarity' does not exist in table 'main.default.diamonds'.") END) ELSE printf("Table 'main.default.diamonds' does not exist.") END

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: learn.microsoft.com

Tags: accessible azure-databricks catalog default na named schema whatever

Share

Link to this answer
Share Copy Link

Contributed on Nov 22 2022

Allie Ubisse

0 Answers  Avg Quality 2/10

---

Closely Related Answers

The following code assumes you have the third-party sample dataset diamonds within a schema named default within a catalog named main that is accessible from your Azure Databricks workspace. If the catalog or schema that you want to use has a different na

Comment

0

USE CATALOG main; USE SCHEMA default; CREATE OR REPLACE FUNCTION table_exists(catalog_name STRING, db_name STRING, table_name STRING) RETURNS BOOLEAN RETURN if( (SELECT count(*) FROM system.information_schema.tables WHERE table_catalog = table_exists.catalog_name AND table_schema = table_exists.db_name AND table_name = table_exists.table_name) > 0, true, false ); CREATE OR REPLACE FUNCTION column_exists(catalog_name STRING, db_name STRING, table_name STRING, column_name STRING) RETURNS BOOLEAN RETURN if( (SELECT count(*) FROM system.information_schema.columns WHERE table_catalog = column_exists.catalog_name AND table_schema = column_exists.db_name AND table_name = column_exists.table_name AND column_name = column_exists.column_name) > 0, true, false ); CREATE OR REPLACE FUNCTION num_rows_for_clarity_in_diamonds(clarity_value STRING) RETURNS BIGINT RETURN SELECT count(*) FROM main.default.diamonds WHERE clarity = clarity_value

Popularity 1/10 Helpfulness 1/10 Language sql

Source: learn.microsoft.com

Tags: named schema accessible azure-databricks sql catalog default na

Share

Link to this answer
Share Copy Link

Contributed on Nov 22 2022

Allie Ubisse

0 Answers  Avg Quality 2/10

---