Last active
February 22, 2022 19:39
-
-
Save Lahannin/9e1f2be43d0067814dabab62bf209d2a to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"dataSources": { | |
"enableCaching": false, | |
"id": "demo-ds", | |
"name": "demo-ds", | |
"pdm": { | |
"tables": [ | |
{ | |
"columns": [ | |
{ | |
"dataType": "NUMERIC", | |
"isPrimaryKey": false, | |
"name": "budget" | |
}, | |
{ | |
"dataType": "STRING", | |
"isPrimaryKey": true, | |
"name": "campaign_channel_id" | |
}, | |
{ | |
"dataType": "INT", | |
"isPrimaryKey": false, | |
"name": "campaign_id", | |
"referencedTableColumn": "campaign_id", | |
"referencedTableId": "campaigns" | |
}, | |
{ | |
"dataType": "STRING", | |
"isPrimaryKey": false, | |
"name": "category" | |
}, | |
{ | |
"dataType": "NUMERIC", | |
"isPrimaryKey": false, | |
"name": "spend" | |
}, | |
{ | |
"dataType": "STRING", | |
"isPrimaryKey": false, | |
"name": "type" | |
} | |
], | |
"id": "campaign_channels", | |
"path": [ | |
"demo", | |
"campaign_channels" | |
], | |
"type": "TABLE" | |
}, | |
{ | |
"columns": [ | |
{ | |
"dataType": "INT", | |
"isPrimaryKey": true, | |
"name": "campaign_id" | |
}, | |
{ | |
"dataType": "STRING", | |
"isPrimaryKey": false, | |
"name": "campaign_name" | |
} | |
], | |
"id": "campaigns", | |
"path": [ | |
"demo", | |
"campaigns" | |
], | |
"type": "TABLE" | |
}, | |
{ | |
"columns": [ | |
{ | |
"dataType": "INT", | |
"isPrimaryKey": true, | |
"name": "customer_id" | |
}, | |
{ | |
"dataType": "STRING", | |
"isPrimaryKey": false, | |
"name": "customer_name" | |
}, | |
{ | |
"dataType": "STRING", | |
"isPrimaryKey": false, | |
"name": "geo__state__location" | |
}, | |
{ | |
"dataType": "STRING", | |
"isPrimaryKey": false, | |
"name": "region" | |
}, | |
{ | |
"dataType": "STRING", | |
"isPrimaryKey": false, | |
"name": "state" | |
} | |
], | |
"id": "customers", | |
"path": [ | |
"demo", | |
"customers" | |
], | |
"type": "TABLE" | |
}, | |
{ | |
"columns": [ | |
{ | |
"dataType": "INT", | |
"isPrimaryKey": false, | |
"name": "campaign_id", | |
"referencedTableColumn": "campaign_id", | |
"referencedTableId": "campaigns" | |
}, | |
{ | |
"dataType": "INT", | |
"isPrimaryKey": false, | |
"name": "customer_id", | |
"referencedTableColumn": "customer_id", | |
"referencedTableId": "customers" | |
}, | |
{ | |
"dataType": "DATE", | |
"isPrimaryKey": false, | |
"name": "date" | |
}, | |
{ | |
"dataType": "STRING", | |
"isPrimaryKey": false, | |
"name": "order_id" | |
}, | |
{ | |
"dataType": "STRING", | |
"isPrimaryKey": true, | |
"name": "order_line_id" | |
}, | |
{ | |
"dataType": "STRING", | |
"isPrimaryKey": false, | |
"name": "order_status" | |
}, | |
{ | |
"dataType": "NUMERIC", | |
"isPrimaryKey": false, | |
"name": "price" | |
}, | |
{ | |
"dataType": "INT", | |
"isPrimaryKey": false, | |
"name": "product_id", | |
"referencedTableColumn": "product_id", | |
"referencedTableId": "products" | |
}, | |
{ | |
"dataType": "NUMERIC", | |
"isPrimaryKey": false, | |
"name": "quantity" | |
}, | |
{ | |
"dataType": "STRING", | |
"isPrimaryKey": false, | |
"name": "wdf__region" | |
}, | |
{ | |
"dataType": "STRING", | |
"isPrimaryKey": false, | |
"name": "wdf__state" | |
} | |
], | |
"id": "order_lines", | |
"path": [ | |
"demo", | |
"order_lines" | |
], | |
"type": "TABLE" | |
}, | |
{ | |
"columns": [ | |
{ | |
"dataType": "STRING", | |
"isPrimaryKey": false, | |
"name": "category" | |
}, | |
{ | |
"dataType": "INT", | |
"isPrimaryKey": true, | |
"name": "product_id" | |
}, | |
{ | |
"dataType": "STRING", | |
"isPrimaryKey": false, | |
"name": "product_name" | |
} | |
], | |
"id": "products", | |
"path": [ | |
"demo", | |
"products" | |
], | |
"type": "TABLE" | |
} | |
] | |
}, | |
"schema": "demo", | |
"type": "POSTGRESQL", | |
"url": "jdbc:postgresql://localhost:5432/demo", | |
"username": "demouser" | |
} | |
], | |
"organization": { | |
"hostname": "localhost", | |
"id": "default", | |
"name": "Default Organization", | |
"oauthClientId": "5c399fd2-53c6-4e75-a570-01541fe9bff7" | |
}, | |
"userGroups": [ | |
{ | |
"id": "adminGroup" | |
} | |
], | |
"users": [ | |
{ | |
"id": "admin", | |
"userGroups": [ | |
{ | |
"id": "adminGroup", | |
"type": "userGroup" | |
} | |
] | |
}, | |
{ | |
"authId": "CiRlMDM0ZTAyNy03NmMxLTRhNzMtOTA3MC1mNThkYWY5MGQxYzUSBWxvY2Fs", | |
"id": "demo", | |
"userGroups": [ | |
{ | |
"id": "adminGroup", | |
"type": "userGroup" | |
} | |
] | |
} | |
], | |
"workspaceDataFilters": [], | |
"workspaces": [ | |
{ | |
"id": "092e88c11dd840f6977fa0c4c37bce8f", | |
"model": { | |
"analytics": { | |
"analyticalDashboards": [ | |
{ | |
"content": { | |
"filterContextRef": { | |
"identifier": { | |
"id": "date_filter", | |
"type": "filterContext" | |
} | |
}, | |
"layout": { | |
"type": "IDashboardLayout", | |
"sections": [ | |
{ | |
"type": "IDashboardLayoutSection", | |
"items": [ | |
{ | |
"type": "IDashboardLayoutItem", | |
"size": { | |
"xl": { | |
"gridWidth": 12 | |
} | |
}, | |
"widget": { | |
"type": "insight", | |
"title": "Total Sales by Year", | |
"description": "", | |
"ignoreDashboardFilters": [], | |
"dateDataSet": { | |
"identifier": { | |
"id": "date", | |
"type": "dataset" | |
} | |
}, | |
"insight": { | |
"identifier": { | |
"id": "total_sales_by_year", | |
"type": "visualizationObject" | |
} | |
}, | |
"drills": [], | |
"properties": {} | |
} | |
} | |
] | |
} | |
] | |
}, | |
"version": "2" | |
}, | |
"description": "A dashboard that provides a visual representation of total sales", | |
"id": "sales_dashboard", | |
"title": "Sales Dashboard" | |
} | |
], | |
"dashboardPlugins": [], | |
"filterContexts": [ | |
{ | |
"content": { | |
"filters": [], | |
"version": "2" | |
}, | |
"description": "", | |
"id": "date_filter", | |
"title": "filterContext" | |
} | |
], | |
"metrics": [ | |
{ | |
"content": { | |
"format": "$#,##0.00", | |
"maql": "SELECT SUM({fact/price}* SUM({fact/quantity}))" | |
}, | |
"description": "The value of all the products sold over time.", | |
"id": "total_sales", | |
"title": "Total Sales" | |
} | |
], | |
"visualizationObjects": [ | |
{ | |
"content": { | |
"buckets": [ | |
{ | |
"items": [ | |
{ | |
"measure": { | |
"localIdentifier": "33f6054078b74dc8912e524f8911d1cc", | |
"definition": { | |
"measureDefinition": { | |
"item": { | |
"identifier": { | |
"id": "total_sales", | |
"type": "metric" | |
} | |
}, | |
"filters": [] | |
} | |
}, | |
"title": "Total Sales" | |
} | |
} | |
], | |
"localIdentifier": "measures" | |
}, | |
{ | |
"items": [ | |
{ | |
"attribute": { | |
"localIdentifier": "ceba9c56516b468ba157e77e6cb6d3a3", | |
"displayForm": { | |
"identifier": { | |
"id": "date.year", | |
"type": "label" | |
} | |
}, | |
"alias": "Year" | |
} | |
} | |
], | |
"localIdentifier": "view" | |
} | |
], | |
"filters": [], | |
"sorts": [], | |
"properties": {}, | |
"visualizationUrl": "local:column", | |
"version": "2" | |
}, | |
"description": "Total Sales by Year", | |
"id": "total_sales_by_year", | |
"title": "Total Sales by Year" | |
} | |
] | |
}, | |
"ldm": { | |
"datasets": [ | |
{ | |
"attributes": [ | |
{ | |
"description": "Campaign channel id", | |
"id": "campaign_channel_id", | |
"labels": [ | |
{ | |
"description": "Campaign channel id", | |
"id": "campaign_channel_id", | |
"primary": true, | |
"sourceColumn": "campaign_channel_id", | |
"tags": [ | |
"Campaign channels" | |
], | |
"title": "Campaign channel id" | |
} | |
], | |
"tags": [ | |
"Campaign channels" | |
], | |
"title": "Campaign channel id" | |
}, | |
{ | |
"description": "Category", | |
"id": "campaign_channels.category", | |
"labels": [ | |
{ | |
"description": "Category", | |
"id": "campaign_channels.category", | |
"primary": true, | |
"sourceColumn": "category", | |
"tags": [ | |
"Campaign channels" | |
], | |
"title": "Category" | |
} | |
], | |
"tags": [ | |
"Campaign channels" | |
], | |
"title": "Category" | |
}, | |
{ | |
"description": "Type", | |
"id": "type", | |
"labels": [ | |
{ | |
"description": "Type", | |
"id": "type", | |
"primary": true, | |
"sourceColumn": "type", | |
"tags": [ | |
"Campaign channels" | |
], | |
"title": "Type" | |
} | |
], | |
"tags": [ | |
"Campaign channels" | |
], | |
"title": "Type" | |
} | |
], | |
"dataSourceTableId": { | |
"dataSourceId": "demo-ds", | |
"id": "campaign_channels", | |
"type": "dataSource" | |
}, | |
"description": "", | |
"facts": [ | |
{ | |
"description": "Budget", | |
"id": "budget", | |
"sourceColumn": "budget", | |
"tags": [ | |
"Campaign channels" | |
], | |
"title": "Budget" | |
}, | |
{ | |
"description": "Spend", | |
"id": "spend", | |
"sourceColumn": "spend", | |
"tags": [ | |
"Campaign channels" | |
], | |
"title": "Spend" | |
} | |
], | |
"grain": [ | |
{ | |
"id": "campaign_channel_id", | |
"type": "attribute" | |
} | |
], | |
"id": "campaign_channels", | |
"references": [ | |
{ | |
"identifier": { | |
"id": "campaigns", | |
"type": "dataset" | |
}, | |
"multivalue": false, | |
"sourceColumns": [ | |
"campaign_id" | |
] | |
} | |
], | |
"tags": [ | |
"Campaign channels" | |
], | |
"title": "Campaign channels" | |
}, | |
{ | |
"attributes": [ | |
{ | |
"description": "Campaign id", | |
"id": "campaign_id", | |
"labels": [ | |
{ | |
"description": "Campaign id", | |
"id": "campaign_id", | |
"primary": true, | |
"sourceColumn": "campaign_id", | |
"tags": [ | |
"Campaigns" | |
], | |
"title": "Campaign id" | |
} | |
], | |
"tags": [ | |
"Campaigns" | |
], | |
"title": "Campaign id" | |
}, | |
{ | |
"description": "Campaign name", | |
"id": "campaign_name", | |
"labels": [ | |
{ | |
"description": "Campaign name", | |
"id": "campaign_name", | |
"primary": true, | |
"sourceColumn": "campaign_name", | |
"tags": [ | |
"Campaigns" | |
], | |
"title": "Campaign name" | |
} | |
], | |
"tags": [ | |
"Campaigns" | |
], | |
"title": "Campaign name" | |
} | |
], | |
"dataSourceTableId": { | |
"dataSourceId": "demo-ds", | |
"id": "campaigns", | |
"type": "dataSource" | |
}, | |
"description": "", | |
"facts": [], | |
"grain": [ | |
{ | |
"id": "campaign_id", | |
"type": "attribute" | |
} | |
], | |
"id": "campaigns", | |
"references": [], | |
"tags": [ | |
"Campaigns" | |
], | |
"title": "Campaigns" | |
}, | |
{ | |
"attributes": [ | |
{ | |
"description": "Customer id", | |
"id": "customer_id", | |
"labels": [ | |
{ | |
"description": "Customer id", | |
"id": "customer_id", | |
"primary": true, | |
"sourceColumn": "customer_id", | |
"tags": [ | |
"Customers" | |
], | |
"title": "Customer id" | |
} | |
], | |
"tags": [ | |
"Customers" | |
], | |
"title": "Customer id" | |
}, | |
{ | |
"description": "Customer name", | |
"id": "customer_name", | |
"labels": [ | |
{ | |
"description": "Customer name", | |
"id": "customer_name", | |
"primary": true, | |
"sourceColumn": "customer_name", | |
"tags": [ | |
"Customers" | |
], | |
"title": "Customer name" | |
} | |
], | |
"tags": [ | |
"Customers" | |
], | |
"title": "Customer name" | |
}, | |
{ | |
"description": "Region", | |
"id": "region", | |
"labels": [ | |
{ | |
"description": "Region", | |
"id": "region", | |
"primary": true, | |
"sourceColumn": "region", | |
"tags": [ | |
"Customers" | |
], | |
"title": "Region" | |
} | |
], | |
"tags": [ | |
"Customers" | |
], | |
"title": "Region" | |
}, | |
{ | |
"description": "State", | |
"id": "state", | |
"labels": [ | |
{ | |
"description": "Location", | |
"id": "geo__state__location", | |
"primary": false, | |
"sourceColumn": "geo__state__location", | |
"tags": [ | |
"Customers" | |
], | |
"title": "Location" | |
}, | |
{ | |
"description": "State", | |
"id": "state", | |
"primary": true, | |
"sourceColumn": "state", | |
"tags": [ | |
"Customers" | |
], | |
"title": "State" | |
} | |
], | |
"tags": [ | |
"Customers" | |
], | |
"title": "State" | |
} | |
], | |
"dataSourceTableId": { | |
"dataSourceId": "demo-ds", | |
"id": "customers", | |
"type": "dataSource" | |
}, | |
"description": "", | |
"facts": [], | |
"grain": [ | |
{ | |
"id": "customer_id", | |
"type": "attribute" | |
} | |
], | |
"id": "customers", | |
"references": [], | |
"tags": [ | |
"Customers" | |
], | |
"title": "Customers" | |
}, | |
{ | |
"attributes": [ | |
{ | |
"description": "Order id", | |
"id": "order_id", | |
"labels": [ | |
{ | |
"description": "Order id", | |
"id": "order_id", | |
"primary": true, | |
"sourceColumn": "order_id", | |
"tags": [ | |
"Order lines" | |
], | |
"title": "Order id" | |
} | |
], | |
"tags": [ | |
"Order lines" | |
], | |
"title": "Order id" | |
}, | |
{ | |
"description": "Order line id", | |
"id": "order_line_id", | |
"labels": [ | |
{ | |
"description": "Order line id", | |
"id": "order_line_id", | |
"primary": true, | |
"sourceColumn": "order_line_id", | |
"tags": [ | |
"Order lines" | |
], | |
"title": "Order line id" | |
} | |
], | |
"tags": [ | |
"Order lines" | |
], | |
"title": "Order line id" | |
}, | |
{ | |
"description": "Order status", | |
"id": "order_status", | |
"labels": [ | |
{ | |
"description": "Order status", | |
"id": "order_status", | |
"primary": true, | |
"sourceColumn": "order_status", | |
"tags": [ | |
"Order lines" | |
], | |
"title": "Order status" | |
} | |
], | |
"tags": [ | |
"Order lines" | |
], | |
"title": "Order status" | |
} | |
], | |
"dataSourceTableId": { | |
"dataSourceId": "demo-ds", | |
"id": "order_lines", | |
"type": "dataSource" | |
}, | |
"description": "", | |
"facts": [ | |
{ | |
"description": "Price", | |
"id": "price", | |
"sourceColumn": "price", | |
"tags": [ | |
"Order lines" | |
], | |
"title": "Price" | |
}, | |
{ | |
"description": "Quantity", | |
"id": "quantity", | |
"sourceColumn": "quantity", | |
"tags": [ | |
"Order lines" | |
], | |
"title": "Quantity" | |
} | |
], | |
"grain": [ | |
{ | |
"id": "order_line_id", | |
"type": "attribute" | |
} | |
], | |
"id": "order_lines", | |
"references": [ | |
{ | |
"identifier": { | |
"id": "campaigns", | |
"type": "dataset" | |
}, | |
"multivalue": false, | |
"sourceColumns": [ | |
"campaign_id" | |
] | |
}, | |
{ | |
"identifier": { | |
"id": "customers", | |
"type": "dataset" | |
}, | |
"multivalue": false, | |
"sourceColumns": [ | |
"customer_id" | |
] | |
}, | |
{ | |
"identifier": { | |
"id": "date", | |
"type": "dataset" | |
}, | |
"multivalue": false, | |
"sourceColumns": [ | |
"date" | |
] | |
}, | |
{ | |
"identifier": { | |
"id": "products", | |
"type": "dataset" | |
}, | |
"multivalue": false, | |
"sourceColumns": [ | |
"product_id" | |
] | |
} | |
], | |
"tags": [ | |
"Order lines" | |
], | |
"title": "Order lines" | |
}, | |
{ | |
"attributes": [ | |
{ | |
"description": "Product id", | |
"id": "product_id", | |
"labels": [ | |
{ | |
"description": "Product id", | |
"id": "product_id", | |
"primary": true, | |
"sourceColumn": "product_id", | |
"tags": [ | |
"Products" | |
], | |
"title": "Product id" | |
} | |
], | |
"tags": [ | |
"Products" | |
], | |
"title": "Product id" | |
}, | |
{ | |
"description": "Product name", | |
"id": "product_name", | |
"labels": [ | |
{ | |
"description": "Product name", | |
"id": "product_name", | |
"primary": true, | |
"sourceColumn": "product_name", | |
"tags": [ | |
"Products" | |
], | |
"title": "Product name" | |
} | |
], | |
"tags": [ | |
"Products" | |
], | |
"title": "Product name" | |
}, | |
{ | |
"description": "Category", | |
"id": "products.category", | |
"labels": [ | |
{ | |
"description": "Category", | |
"id": "products.category", | |
"primary": true, | |
"sourceColumn": "category", | |
"tags": [ | |
"Products" | |
], | |
"title": "Category" | |
} | |
], | |
"tags": [ | |
"Products" | |
], | |
"title": "Category" | |
} | |
], | |
"dataSourceTableId": { | |
"dataSourceId": "demo-ds", | |
"id": "products", | |
"type": "dataSource" | |
}, | |
"description": "", | |
"facts": [], | |
"grain": [ | |
{ | |
"id": "product_id", | |
"type": "attribute" | |
} | |
], | |
"id": "products", | |
"references": [], | |
"tags": [ | |
"Products" | |
], | |
"title": "Products" | |
} | |
], | |
"dateInstances": [ | |
{ | |
"description": "", | |
"granularities": [ | |
"MINUTE", | |
"HOUR", | |
"DAY", | |
"WEEK", | |
"MONTH", | |
"QUARTER", | |
"YEAR", | |
"MINUTE_OF_HOUR", | |
"HOUR_OF_DAY", | |
"DAY_OF_WEEK", | |
"DAY_OF_MONTH", | |
"DAY_OF_YEAR", | |
"WEEK_OF_YEAR", | |
"MONTH_OF_YEAR", | |
"QUARTER_OF_YEAR" | |
], | |
"granularitiesFormatting": { | |
"titleBase": "", | |
"titlePattern": "%titleBase - %granularityTitle" | |
}, | |
"id": "date", | |
"tags": [ | |
"Date" | |
], | |
"title": "Date" | |
} | |
] | |
} | |
}, | |
"name": "Analytics as Code" | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment