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
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 688 Automate
- 177 Apps
- 453 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive