Hi ,I am getting this Error:WHERE 1=0, Error message from Server: Configuration db table is not available. I am using PySpark and JDBC connection. Please help on this.
@szymon_dybczak Can you help us on this? Or could you provide a complete structure/steps how to connect with databricks using PySpark and JDBC step by step . Like initiate spark session then JDBC connection url then sql read all these in details.Also...
@szymon_dybczak ,No it's again throwing same type of exceptions[Databricks][JDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: null, Query: SELECT * FROM (SELECT * FROM scna_qa.dsml.geonode_sku_dategrp_kpi) SPARK_GEN_SUBQ...
@szymon_dybczak I also tried the another approach you provided, jdbc_url = f"jdbc:databricks://{os.environ[db_const.DATA_BRICKS_HOST]};" \f"transportMode=http;" \f"ssl=1;" \f"httpPath={os.environ[db_const.DATA_BRICKS_HTTP_PATH]};" \f"AuthMech=3;" \f...
This is the query I already defined - query = 'select * from scna_qa.dsml.geonode_sku_dategrp_kpi' jdbc_url = f"jdbc:databricks://{os.environ[db_const.DATA_BRICKS_HOST]};" \f"transportMode=http;" \f"ssl=1;" \f"httpPath={os.environ[db_const.DATA_BRICK...
