github-actions[bot]
commented
1 month ago ❌ 35/36 passed, 1 failed, 2 skipped, 21m37s total
❌ test_dashboards_creates_dashboard_with_replace_database: databricks.sdk.errors.platform.BadRequest: [INSUFFICIENT_PERMISSIONS] Insufficient privileges: (4.395s)
``` databricks.sdk.errors.platform.BadRequest: [INSUFFICIENT_PERMISSIONS] Insufficient privileges: User does not have permission CREATE on CATALOG. SQLSTATE: 42501 06:57 DEBUG [databricks.sdk] Loaded from environment 06:57 DEBUG [databricks.sdk] Ignoring pat auth, because metadata-service is preferred 06:57 DEBUG [databricks.sdk] Ignoring basic auth, because metadata-service is preferred 06:57 DEBUG [databricks.sdk] Attempting to configure auth: metadata-service 06:57 INFO [databricks.sdk] Using Databricks Metadata Service authentication [gw9] linux -- Python 3.10.14 /home/runner/work/lsql/lsql/.venv/bin/python 06:57 DEBUG [databricks.sdk] Loaded from environment 06:57 DEBUG [databricks.sdk] Ignoring pat auth, because metadata-service is preferred 06:57 DEBUG [databricks.sdk] Ignoring basic auth, because metadata-service is preferred 06:57 DEBUG [databricks.sdk] Attempting to configure auth: metadata-service 06:57 INFO [databricks.sdk] Using Databricks Metadata Service authentication 06:57 DEBUG [databricks.sdk] POST /api/2.0/lakeview/dashboards > { > "display_name": "created_by_lsql_cV5jY02D6EU9Zt7H" > } < 200 OK < { < "create_time": "2024-08-05T06:57:55.769Z", < "dashboard_id": "01ef52f80ac31076aacf85e54fadee3a", < "display_name": "created_by_lsql_cV5jY02D6EU9Zt7H", < "etag": "-557926310", < "lifecycle_state": "ACTIVE", < "parent_path": "/Users/4106dc97-a963-48f0-a079-a578238959a6", < "path": "/Users/4106dc97-a963-48f0-a079-a578238959a6/created_by_lsql_cV5jY02D6EU9Zt7H.lvdash.json", < "serialized_dashboard": "{\"pages\":[{\"name\":\"8bbc0244\",\"displayName\":\"New Page\"}]}", < "update_time": "2024-08-05T06:57:56.030Z" < } 06:57 DEBUG [databricks.labs.lsql.backends] [api][execute] CREATE SCHEMA hive_metastore.lsql_sz7lx WITH DBPROPERTIES (RemoveAfter=2024080508) 06:57 DEBUG [databricks.labs.lsql.core] Executing SQL statement: CREATE SCHEMA hive_metastore.lsql_sz7lx WITH DBPROPERTIES (RemoveAfter=2024080508) 06:57 DEBUG [databricks.sdk] POST /api/2.0/sql/statements/ > { > "format": "JSON_ARRAY", > "statement": "CREATE SCHEMA hive_metastore.lsql_sz7lx WITH DBPROPERTIES (RemoveAfter=2024080508)", > "warehouse_id": "TEST_DEFAULT_WAREHOUSE_ID" > } < 200 OK < { < "statement_id": "01ef52f8-0b14-1644-b27d-67512b58f7fb", < "status": { < "error": { < "error_code": "BAD_REQUEST", < "message": "[INSUFFICIENT_PERMISSIONS] Insufficient privileges:\nUser does not have permission CREATE on CATA... (20 more bytes)" < }, < "state": "FAILED" < } < } 06:57 DEBUG [databricks.sdk] Loaded from environment 06:57 DEBUG [databricks.sdk] Ignoring pat auth, because metadata-service is preferred 06:57 DEBUG [databricks.sdk] Ignoring basic auth, because metadata-service is preferred 06:57 DEBUG [databricks.sdk] Attempting to configure auth: metadata-service 06:57 INFO [databricks.sdk] Using Databricks Metadata Service authentication 06:57 DEBUG [databricks.sdk] POST /api/2.0/lakeview/dashboards > { > "display_name": "created_by_lsql_cV5jY02D6EU9Zt7H" > } < 200 OK < { < "create_time": "2024-08-05T06:57:55.769Z", < "dashboard_id": "01ef52f80ac31076aacf85e54fadee3a", < "display_name": "created_by_lsql_cV5jY02D6EU9Zt7H", < "etag": "-557926310", < "lifecycle_state": "ACTIVE", < "parent_path": "/Users/4106dc97-a963-48f0-a079-a578238959a6", < "path": "/Users/4106dc97-a963-48f0-a079-a578238959a6/created_by_lsql_cV5jY02D6EU9Zt7H.lvdash.json", < "serialized_dashboard": "{\"pages\":[{\"name\":\"8bbc0244\",\"displayName\":\"New Page\"}]}", < "update_time": "2024-08-05T06:57:56.030Z" < } 06:57 DEBUG [databricks.labs.lsql.backends] [api][execute] CREATE SCHEMA hive_metastore.lsql_sz7lx WITH DBPROPERTIES (RemoveAfter=2024080508) 06:57 DEBUG [databricks.labs.lsql.core] Executing SQL statement: CREATE SCHEMA hive_metastore.lsql_sz7lx WITH DBPROPERTIES (RemoveAfter=2024080508) 06:57 DEBUG [databricks.sdk] POST /api/2.0/sql/statements/ > { > "format": "JSON_ARRAY", > "statement": "CREATE SCHEMA hive_metastore.lsql_sz7lx WITH DBPROPERTIES (RemoveAfter=2024080508)", > "warehouse_id": "TEST_DEFAULT_WAREHOUSE_ID" > } < 200 OK < { < "statement_id": "01ef52f8-0b14-1644-b27d-67512b58f7fb", < "status": { < "error": { < "error_code": "BAD_REQUEST", < "message": "[INSUFFICIENT_PERMISSIONS] Insufficient privileges:\nUser does not have permission CREATE on CATA... (20 more bytes)" < }, < "state": "FAILED" < } < } 06:57 DEBUG [databricks.sdk] DELETE /api/2.0/lakeview/dashboards/01ef52f80ac31076aacf85e54fadee3a < 200 OK < {} [gw9] linux -- Python 3.10.14 /home/runner/work/lsql/lsql/.venv/bin/python ```Running from acceptance #345
_widgetsuffix to the name of the widget object in the dashboards.py file. This change ensures consistency between the widget name and the id of the query, facilitating user understanding of the relationship between the two. A new method, _get_query_widget_spec, has also been added, although its specific functionality requires further investigation. Additionally, the unit tests in thetests/unit/test_dashboards.pyfile have been updated to check for the presence of the_widgetsuffix in widget names, ensuring that the tests accurately reflect the desired behavior. These changes improve the consistency of dashboard widget naming, thus benefiting software engineers utilizing or extending the project's widget-ordering functionalities.