Survey banner
The Dataiku Community is moving to a new home! Some short term disruption starting next week: LEARN MORE

Extracting Dataset names?

Mrcello89
Level 2
Extracting Dataset names?

Hi everyone, 

 

This may seem a trivial questione, but do you know if there is a way to export all the tables'names for the Dataset list provided in the screen 'Dataset' G+D?

 

Thnaks for help.

0 Kudos
1 Reply
tgb417

@Mrcello89 

Welcome to the Dataiku Community.  We are glad to have you join us.

If you are able to do a little bit of Python Coding this thread here in the community might be of some help.

https://community.dataiku.com/t5/Using-Dataiku/List-of-all-project-and-respective-tables-in-dataiku/...

Also from this thread https://community.dataiku.com/t5/Using-Dataiku/How-to-get-a-list-of-the-datasets-in-a-notebook/m-p/3.... I adapted the following code.  Note this provides a lot of data on each dataset.

# -------------------------------------------------------------------------------- NOTEBOOK-CELL: CODE
# -*- coding: utf-8 -*-
import dataiku
import pandas as pd, numpy as np
from dataiku import pandasutils as pdu

# -------------------------------------------------------------------------------- NOTEBOOK-CELL: CODE
project_name = "FF_TYPICAL_DATA_CLEANUP" # You can find this in the Project URL

client = dataiku.api_client()
project = client.get_project(project_name)
datasets = project.list_datasets()

# -------------------------------------------------------------------------------- NOTEBOOK-CELL: CODE
# Write recipe outputs
output_data_set_name = "test" #This can be found on the right side of a Python Code Recipe Screen

test = dataiku.Dataset(output_data_set_name)
test.write_with_schema(pd.DataFrame.from_records(datasets))

Hope this helps a bit.

--Tom