Test failure: test_dashboards_creates_exported_dashboard_definition #415
Description
❌ test_dashboards_creates_exported_dashboard_definition: assert {'datasets': ...: 'queries'}]} == {'datasets': ...: 'queries'}]} (13.365s)
assert {'datasets': ...: 'queries'}]} == {'datasets': ...: 'queries'}]}
Omitting 1 identical items, use -vv to show
Differing items:
{'datasets': [{'displayName': 'counter', 'name': 'counter', 'query': 'SELECT 6217 AS count'}, {'displayName': 'office_...0 University Ave, Suite 722', 'Berkeley', 'CA', '94704', 'USA') AS tab(Address, City, State, `Zip Code`, Country)\n"}]} != {'datasets': [{'displayName': 'counter', 'name': 'counter'}, {'displayName': 'office_locations', 'name': 'office_locations'}]}
Full diff:
{
'datasets': [
{
'displayName': 'counter',
'name': 'counter',
+ 'query': 'SELECT 6217 AS count',
},
{
'displayName': 'office_locations',
'name': 'office_locations',
+ 'query': 'SELECT\n'
+ ' Address,\n'
+ ' City,\n'
+ ' State,\n'
+ ' `Zip Code`,\n'
+ ' Country\n'
+ 'FROM\n'
+ 'VALUES\n'
+ " ('160 Spear St 15th Floor', 'San Francisco', 'CA', '94105', "
+ "'USA'),\n"
+ " ('756 W Peachtree St NW, Suite 03W114', 'Atlanta', 'GA', "
+ "'30308', 'USA'),\n"
+ " ('500 108th Ave NE, Suite 1820', 'Bellevue', 'WA', '98004', "
+ "'USA'),\n"
+ " ('125 High St, Suite 220', 'Boston', 'MA', '02110', 'USA'),\n"
+ " ('2120 University Ave, Suite 722', 'Berkeley', 'CA', '94704', "
+ "'USA') AS tab(Address, City, State, `Zip Code`, Country)\n",
},
],
'pages': [
{
'displayName': 'queries',
'layout': [
{
'position': {
'height': 3,
'width': 1,
'x': 0,
'y': 0,
},
'widget': {
'name': 'counter',
'queries': [
{
'name': 'main_query',
'query': {
'datasetName': 'counter',
'disaggregated': True,
'fields': [
{
'expression': '`count`',
'name': 'count',
},
],
},
},
],
'spec': {
'encodings': {
'value': {
'displayName': 'count',
'fieldName': 'count',
},
},
'version': 2,
'widgetType': 'counter',
},
},
},
{
'position': {
'height': 5,
'width': 3,
'x': 1,
'y': 0,
},
'widget': {
'name': 'table',
'queries': [
{
'name': 'main_query',
'query': {
'datasetName': 'office_locations',
'disaggregated': True,
'fields': [
{
'expression': '`Address`',
'name': 'Address',
},
{
'expression': '`City`',
'name': 'City',
},
{
'expression': '`State`',
'name': 'State',
},
{
'expression': '`Zip Code`',
'name': 'Zip Code',
},
{
'expression': '`Country`',
'name': 'Country',
},
],
},
},
],
'spec': {
'allowHTMLByDefault': False,
'condensed': True,
'encodings': {
'columns': [
{
'alignContent': 'left',
'allowHTML': False,
'allowSearch': False,
'booleanValues': [
'false',
'true',
],
'displayAs': 'string',
'displayName': 'Address',
'fieldName': 'Address',
'highlightLinks': False,
'imageHeight': '',
'imageTitleTemplate': '{{ @ }}',
'imageUrlTemplate': '{{ @ }}',
'imageWidth': '',
'linkOpenInNewTab': True,
'linkTextTemplate': '{{ @ }}',
'linkTitleTemplate': '{{ @ }}',
'linkUrlTemplate': '{{ @ }}',
'order': 100000,
'preserveWhitespace': False,
'title': 'Address',
'type': 'string',
'useMonospaceFont': False,
'visible': True,
},
{
'alignContent': 'left',
'allowHTML': False,
'allowSearch': False,
'booleanValues': [
'false',
'true',
],
'displayAs': 'string',
'displayName': 'City',
'fieldName': 'City',
'highlightLinks': False,
'imageHeight': '',
'imageTitleTemplate': '{{ @ }}',
'imageUrlTemplate': '{{ @ }}',
'imageWidth': '',
'linkOpenInNewTab': True,
'linkTextTemplate': '{{ @ }}',
'linkTitleTemplate': '{{ @ }}',
'linkUrlTemplate': '{{ @ }}',
'order': 100001,
'preserveWhitespace': False,
'title': 'City',
'type': 'string',
'useMonospaceFont': False,
'visible': True,
},
{
'alignContent': 'left',
'allowHTML': False,
'allowSearch': False,
'booleanValues': [
'false',
'true',
],
'displayAs': 'string',
'displayName': 'State',
'fieldName': 'State',
'highlightLinks': False,
'imageHeight': '',
'imageTitleTemplate': '{{ @ }}',
'imageUrlTemplate': '{{ @ }}',
'imageWidth': '',
'linkOpenInNewTab': True,
'linkTextTemplate': '{{ @ }}',
'linkTitleTemplate': '{{ @ }}',
'linkUrlTemplate': '{{ @ }}',
'order': 100002,
'preserveWhitespace': False,
'title': 'State',
'type': 'string',
'useMonospaceFont': False,
'visible': True,
},
{
'alignContent': 'left',
'allowHTML': False,
'allowSearch': False,
'booleanValues': [
'false',
'true',
],
'displayAs': 'string',
'displayName': 'Zip Code',
'fieldName': 'Zip Code',
'highlightLinks': False,
'imageHeight': '',
'imageTitleTemplate': '{{ @ }}',
'imageUrlTemplate': '{{ @ }}',
'imageWidth': '',
'linkOpenInNewTab': True,
'linkTextTemplate': '{{ @ }}',
'linkTitleTemplate': '{{ @ }}',
'linkUrlTemplate': '{{ @ }}',
'order': 100003,
'preserveWhitespace': False,
'title': 'Zip Code',
'type': 'string',
'useMonospaceFont': False,
'visible': True,
},
{
'alignContent': 'left',
'allowHTML': False,
'allowSearch': False,
'booleanValues': [
'false',
'true',
],
'displayAs': 'string',
'displayName': 'Country',
'fieldName': 'Country',
'highlightLinks': False,
'imageHeight': '',
'imageTitleTemplate': '{{ @ }}',
'imageUrlTemplate': '{{ @ }}',
'imageWidth': '',
'linkOpenInNewTab': True,
'linkTextTemplate': '{{ @ }}',
'linkTitleTemplate': '{{ @ }}',
'linkUrlTemplate': '{{ @ }}',
'order': 100004,
'preserveWhitespace': False,
'title': 'Country',
'type': 'string',
'useMonospaceFont': False,
'visible': True,
},
],
},
'invisibleColumns': [],
'itemsPerPage': 25,
'paginationSize': 'TEST_SCHEMA',
'version': 1,
'widgetType': 'table',
'withRowNumber': False,
},
},
},
],
'name': 'queries',
},
],
}
04:52 DEBUG [databricks.sdk] Loaded from environment
04:52 DEBUG [databricks.sdk] Ignoring pat auth, because metadata-service is preferred
04:52 DEBUG [databricks.sdk] Ignoring basic auth, because metadata-service is preferred
04:52 DEBUG [databricks.sdk] Attempting to configure auth: metadata-service
04:52 INFO [databricks.sdk] Using Databricks Metadata Service authentication
[gw6] linux -- Python 3.10.18 /home/runner/work/lsql/lsql/.venv/bin/python
04:52 DEBUG [databricks.sdk] Loaded from environment
04:52 DEBUG [databricks.sdk] Ignoring pat auth, because metadata-service is preferred
04:52 DEBUG [databricks.sdk] Ignoring basic auth, because metadata-service is preferred
04:52 DEBUG [databricks.sdk] Attempting to configure auth: metadata-service
04:52 INFO [databricks.sdk] Using Databricks Metadata Service authentication
04:52 DEBUG [databricks.sdk] POST /api/2.0/lakeview/dashboards
> {
> "display_name": "created_by_lsql_leWenlL3gx7lajsy"
> }
< 200 OK
< {
< "create_time": "2025-07-02T04:52:26.857Z",
< "dashboard_id": "01f0570059e917f69a42055f7800fee4",
< "display_name": "created_by_lsql_leWenlL3gx7lajsy",
< "etag": "1921179403",
< "lifecycle_state": "ACTIVE",
< "parent_path": "/Users/4106dc97-a963-48f0-a079-a578238959a6",
< "path": "/Users/4106dc97-a963-48f0-a079-a578238959a6/created_by_lsql_leWenlL3gx7lajsy.lvdash.json",
< "serialized_dashboard": "{}\n",
< "update_time": "2025-07-02T04:52:37.592Z"
< }
04:52 DEBUG [databricks.sdk] PATCH /api/2.0/lakeview/dashboards/01f0570059e917f69a42055f7800fee4
> {
> "create_time": "2025-07-02T04:52:26.857Z",
> "dashboard_id": "01f0570059e917f69a42055f7800fee4",
> "display_name": "created_by_lsql_leWenlL3gx7lajsy",
> "etag": "1921179403",
> "lifecycle_state": "ACTIVE",
> "parent_path": "/Users/4106dc97-a963-48f0-a079-a578238959a6",
> "path": "/Users/4106dc97-a963-48f0-a079-a578238959a6/created_by_lsql_leWenlL3gx7lajsy.lvdash.json",
> "serialized_dashboard": "{\n \"datasets\": [\n {\n \"name\": \"6e3ba8d4\",\n \"displayName\": \"counter\",\n \"query\":... (8678 more bytes)",
> "update_time": "2025-07-02T04:52:37.592Z"
> }
< 200 OK
< {
< "create_time": "2025-07-02T04:52:26.857Z",
< "dashboard_id": "01f0570059e917f69a42055f7800fee4",
< "display_name": "created_by_lsql_leWenlL3gx7lajsy",
< "etag": "3200144568",
< "lifecycle_state": "ACTIVE",
< "parent_path": "/Users/4106dc97-a963-48f0-a079-a578238959a6",
< "path": "/Users/4106dc97-a963-48f0-a079-a578238959a6/created_by_lsql_leWenlL3gx7lajsy.lvdash.json",
< "serialized_dashboard": "{\n \"datasets\": [\n {\n \"name\": \"6e3ba8d4\",\n \"displayName\": \"counter\",\n \"queryLi... (8907 more bytes)",
< "update_time": "2025-07-02T04:52:37.982Z"
< }
04:52 DEBUG [databricks.sdk] GET /api/2.0/workspace/export?path=/Users/4106dc97-a963-48f0-a079-a578238959a6/created_by_lsql_leWenlL3gx7lajsy.lvdash.json&direct_download=true&format=SOURCE
< 200 OK
< {
< "datasets": [
< {
< "displayName": "counter",
< "name": "6e3ba8d4",
< "queryLines": [
< "SELECT 6217 AS count"
< ]
< },
< {
< "displayName": "office_locations",
< "name": "2227898d",
< "queryLines": [
< "SELECT\n",
< "... (12 additional elements)"
< ]
< }
< ],
< "pages": [
< {
< "displayName": "queries",
< "layout": [
< {
< "position": {
< "height": 3,
< "width": 1,
< "x": 0,
< "y": 0
< },
< "widget": {
< "name": "3c6ea3cb",
< "queries": [
< {
< "name": "main_query",
< "query": {
< "datasetName": "6e3ba8d4",
< "disaggregated": true,
< "fields": [
< {
< "expression": "`count`",
< "name": "count"
< }
< ]
< }
< }
< ],
< "spec": {
< "encodings": {
< "value": "**REDACTED**"
< },
< "version": 2,
< "widgetType": "counter"
< }
< }
< },
< "... (1 additional elements)"
< ],
< "name": "0d510dbf",
< "pageType": "PAGE_TYPE_CANVAS"
< }
< ]
< }
04:52 DEBUG [databricks.sdk] Loaded from environment
04:52 DEBUG [databricks.sdk] Ignoring pat auth, because metadata-service is preferred
04:52 DEBUG [databricks.sdk] Ignoring basic auth, because metadata-service is preferred
04:52 DEBUG [databricks.sdk] Attempting to configure auth: metadata-service
04:52 INFO [databricks.sdk] Using Databricks Metadata Service authentication
04:52 DEBUG [databricks.sdk] POST /api/2.0/lakeview/dashboards
> {
> "display_name": "created_by_lsql_leWenlL3gx7lajsy"
> }
< 200 OK
< {
< "create_time": "2025-07-02T04:52:26.857Z",
< "dashboard_id": "01f0570059e917f69a42055f7800fee4",
< "display_name": "created_by_lsql_leWenlL3gx7lajsy",
< "etag": "1921179403",
< "lifecycle_state": "ACTIVE",
< "parent_path": "/Users/4106dc97-a963-48f0-a079-a578238959a6",
< "path": "/Users/4106dc97-a963-48f0-a079-a578238959a6/created_by_lsql_leWenlL3gx7lajsy.lvdash.json",
< "serialized_dashboard": "{}\n",
< "update_time": "2025-07-02T04:52:37.592Z"
< }
04:52 DEBUG [databricks.sdk] PATCH /api/2.0/lakeview/dashboards/01f0570059e917f69a42055f7800fee4
> {
> "create_time": "2025-07-02T04:52:26.857Z",
> "dashboard_id": "01f0570059e917f69a42055f7800fee4",
> "display_name": "created_by_lsql_leWenlL3gx7lajsy",
> "etag": "1921179403",
> "lifecycle_state": "ACTIVE",
> "parent_path": "/Users/4106dc97-a963-48f0-a079-a578238959a6",
> "path": "/Users/4106dc97-a963-48f0-a079-a578238959a6/created_by_lsql_leWenlL3gx7lajsy.lvdash.json",
> "serialized_dashboard": "{\n \"datasets\": [\n {\n \"name\": \"6e3ba8d4\",\n \"displayName\": \"counter\",\n \"query\":... (8678 more bytes)",
> "update_time": "2025-07-02T04:52:37.592Z"
> }
< 200 OK
< {
< "create_time": "2025-07-02T04:52:26.857Z",
< "dashboard_id": "01f0570059e917f69a42055f7800fee4",
< "display_name": "created_by_lsql_leWenlL3gx7lajsy",
< "etag": "3200144568",
< "lifecycle_state": "ACTIVE",
< "parent_path": "/Users/4106dc97-a963-48f0-a079-a578238959a6",
< "path": "/Users/4106dc97-a963-48f0-a079-a578238959a6/created_by_lsql_leWenlL3gx7lajsy.lvdash.json",
< "serialized_dashboard": "{\n \"datasets\": [\n {\n \"name\": \"6e3ba8d4\",\n \"displayName\": \"counter\",\n \"queryLi... (8907 more bytes)",
< "update_time": "2025-07-02T04:52:37.982Z"
< }
04:52 DEBUG [databricks.sdk] GET /api/2.0/workspace/export?path=/Users/4106dc97-a963-48f0-a079-a578238959a6/created_by_lsql_leWenlL3gx7lajsy.lvdash.json&direct_download=true&format=SOURCE
< 200 OK
< {
< "datasets": [
< {
< "displayName": "counter",
< "name": "6e3ba8d4",
< "queryLines": [
< "SELECT 6217 AS count"
< ]
< },
< {
< "displayName": "office_locations",
< "name": "2227898d",
< "queryLines": [
< "SELECT\n",
< "... (12 additional elements)"
< ]
< }
< ],
< "pages": [
< {
< "displayName": "queries",
< "layout": [
< {
< "position": {
< "height": 3,
< "width": 1,
< "x": 0,
< "y": 0
< },
< "widget": {
< "name": "3c6ea3cb",
< "queries": [
< {
< "name": "main_query",
< "query": {
< "datasetName": "6e3ba8d4",
< "disaggregated": true,
< "fields": [
< {
< "expression": "`count`",
< "name": "count"
< }
< ]
< }
< }
< ],
< "spec": {
< "encodings": {
< "value": "**REDACTED**"
< },
< "version": 2,
< "widgetType": "counter"
< }
< }
< },
< "... (1 additional elements)"
< ],
< "name": "0d510dbf",
< "pageType": "PAGE_TYPE_CANVAS"
< }
< ]
< }
04:52 DEBUG [databricks.sdk] DELETE /api/2.0/lakeview/dashboards/01f0570059e917f69a42055f7800fee4
< 200 OK
< {}
[gw6] linux -- Python 3.10.18 /home/runner/work/lsql/lsql/.venv/bin/python
Running from nightly #232