Download the Schema of a dataset
Comments
-
Probably not the answer you're looking for but I think you can only do something like that by utilizing the API.
Ex. I have a short python script that I have to get a specific datasets details which includes information about the dataset and the schema. So via the API you could get a list of all dataset ID's in your system and then loop through those and create the schema for all of them assuming you know how.
{'columns': 480,
'createdAt': '2017-01-11T17:53:17Z',
'dataCurrentAt': '2019-04-30T07:23:12Z',
'description': 'Select All on JIRA',
'id': '45hgrdd3-1w4r-789r-j65f-4aeb1a20g357',
'name': 'JIRA - All Data',
'owner': {'id': 1686765431, 'name': 'Travis Simpson'},
'pdpEnabled': False,
'policies': [{'filters': [],
'groups': [],
'id': 51,
'name': 'All Rows',
'type': 'open',
'users': []}],
'rows': 39021,
'schema': {'columns': [{'name': 'issue_id', 'type': 'LONG'},
{'name': 'issue_key', 'type': 'STRING'},
{'name': 'Status Category Changed', 'type': 'STRING'},
{'name': 'Resolution', 'type': 'STRING'},
{'name': 'Release - Distribution List Notification',
'type': 'STRING'},
{'name': 'Parent Link_hasEpicLinkFieldDependency',
'type': 'STRING'},
{'name': 'Parent Link_showField', 'type': 'STRING'},'updatedAt': '2019-04-30T07:23:12Z'}
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0 -
My original message dissapeared so re-adding, sorry if you get notified twice.
This probably isn't the answer you want but I think it's only possible via the API. I have a script that gets the response from one of the API endpoints which returns the text seen below. You could do the following to generate the schema for all datasets programatically.
1: GET request to the datasets endpoint which would return information around ALL datasets in your system, which includes the dataset id.
2: Loop through all dataset id's found in #1 and make a GET request to datasets endpoint and supply the dataset ID. It will return info specific to that dataset including the schema which you could deserialize and format. (response example below).
{'columns': 480,
'createdAt': '2017-01-11T17:53:17Z',
'dataCurrentAt': '2019-04-30T07:23:12Z',
'description': 'Select All on JIRA',
'id': '87cfecc2-0d9g-447r-t65e-4aeb1b43d678',
'name': 'JIRA - All Data',
'owner': {'id': 1686425654, 'name': 'Travis Simpson'},
'pdpEnabled': False,
'policies': [{'filters': [],
'groups': [],
'id': 51,
'name': 'All Rows',
'type': 'open',
'users': []}],
'rows': 39021,
'schema': {'columns': [{'name': 'issue_id', 'type': 'LONG'},
{'name': 'issue_key', 'type': 'STRING'},
{'name': 'Status Category Changed', 'type': 'STRING'},
{'name': 'Resolution', 'type': 'STRING'},
{'name': 'Release - Distribution List Notification',
'type': 'STRING'},
{'name': 'Parent Link_hasEpicLinkFieldDependency',
'type': 'STRING'},
{'name': 'Parent Link_showField', 'type': 'STRING'},
{'name': 'Parent Link_nonEditableReason_reason',
'type': 'STRING'},
{'name': 'Parent Link_nonEditableReason_message',
'type': 'STRING'},'updatedAt': '2019-04-30T07:23:12Z'}
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0 -
You will want to look at the Domo Governance Datasets. This is available in the app store via a connector. Do a search for Domo Governance Datasets and you should find it.
There is a dataset available for Dataset Schema which will give you a nice format to create Domo reports or to export.
Chris
-----------------
Chris0
Categories
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 474 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 215 Visualize
- 259 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 191 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive