Hi I m trying to delete all data imported from Tableau and t DataHub #integrate-tableau-datahub

Hi! I'm trying to delete all data imported from T...

brainy-wall-41694

04/29/2022, 1:10 PM

Hi! I'm trying to delete all data imported from Tableau and the data is not deleted. Anyone else had this problem?

datahub delete --platform Tableau --hard

teamwork 1

loud-island-88694

04/29/2022, 7:16 PM

@early-lamp-41924 @incalculable-ocean-74010 ^

incalculable-ocean-74010

04/29/2022, 8:35 PM

Hello Cristian, Is this a datahub instance deployed via the cli?

mammoth-bear-12532

04/29/2022, 8:46 PM

@brainy-wall-41694 you need

--entity_type dashboard

in addition

mammoth-bear-12532

04/29/2022, 8:46 PM

https://datahubproject.io/docs/how/delete-metadata/#delete-all-looker-dashboards-and-charts

mammoth-bear-12532

04/29/2022, 8:46 PM

also check the casing of

Tableau

versus

tableau

I'm not 100% sure if we handle it perfectly

brainy-wall-41694

05/02/2022, 8:18 PM

@incalculable-ocean-74010 Through the command:

datahub docker quickstart

brainy-wall-41694

05/02/2022, 8:20 PM

@mammoth-bear-12532 I've tried with

Tableau

tableau

and including

--entity_type dashboard

--entity_type charts

and

--entity_type dataset

, but nothing worked.

mammoth-bear-12532

05/03/2022, 5:40 AM

@brainy-wall-41694: can you ensure that you are connected to the same datahub?

datahub init

will allow you to set the datahub instance that you connect to by default (in a non ingest scenario)

mammoth-bear-12532

05/03/2022, 5:40 AM

I just tried this and it worked. Looks like tableau can generate dashboards, charts, datasets and containers

mammoth-bear-12532

05/03/2022, 5:41 AM

Copy code

❯ datahub delete --entity_type dashboard --platform tableau
[2022-05-02 22:35:08,979] INFO     {datahub.cli.delete_cli:209} - datahub configured with <http://localhost:8080>
[2022-05-02 22:35:09,130] INFO     {datahub.cli.delete_cli:222} - Filter matched 4 entities. Sample: ['urn:li:dashboard:(tableau,39b7a1de-6276-cfc7-9b59-1d22f3bbb06b)', 'urn:li:dashboard:(tableau,5dcaaf46-e6fb-2548-e763-272a7ab2c9b1)', 'urn:li:dashboard:(tableau,8f7dd564-36b6-593f-3c6f-687ad06cd40b)', 'urn:li:dashboard:(tableau,20e44c22-1ccd-301a-220c-7b6837d09a52)']
This will delete 4 entities. Are you sure? [y/N]: y
100% (4 of 4) |#####################################################################################################################################################################| Elapsed Time: 0:00:00 Time:  0:00:00
Took 18.218 seconds to soft delete -1 rows for 4 entities
❯ datahub delete --entity_type chart --platform tableau
[2022-05-02 22:36:08,365] INFO     {datahub.cli.delete_cli:209} - datahub configured with <http://localhost:8080>
[2022-05-02 22:36:08,666] INFO     {datahub.cli.delete_cli:222} - Filter matched 24 entities. Sample: ['urn:li:chart:(tableau,f4317efd-c3e6-6ace-8fe6-e71b590bbbcc)', 'urn:li:chart:(tableau,2b5351c1-535d-4a4a-1339-c51ddd6abf8a)', 'urn:li:chart:(tableau,8a6a269a-d6de-fae4-5050-513255b40ffc)', 'urn:li:chart:(tableau,8385ea9a-0749-754f-7ad9-824433de2120)', 'urn:li:chart:(tableau,b207c2f2-b675-32e3-2663-17bb836a018b)']
This will delete 24 entities. Are you sure? [y/N]: y
100% (24 of 24) |###################################################################################################################################################################| Elapsed Time: 0:00:00 Time:  0:00:00
Took 5.769 seconds to soft delete -1 rows for 24 entities
❯ datahub delete --entity_type dataset --platform tableau
[2022-05-02 22:38:23,869] INFO     {datahub.cli.delete_cli:209} - datahub configured with <http://localhost:8080>
[2022-05-02 22:38:24,018] INFO     {datahub.cli.delete_cli:222} - Filter matched 12 entities. Sample: ['urn:li:dataset:(urn:li:dataPlatform:tableau,618c87db-5959-338b-bcc7-6f5f4cc0b6c6,PROD)', 'urn:li:dataset:(urn:li:dataPlatform:tableau,801c95e3-b07e-7bfe-3789-a561c7beccd3,PROD)', 'urn:li:dataset:(urn:li:dataPlatform:tableau,3ade7817-ae27-259e-8e48-1570e7f932f6,PROD)', 'urn:li:dataset:(urn:li:dataPlatform:tableau,dfe2c02a-54b7-f7a2-39fc-c651da2f6ad8,PROD)', 'urn:li:dataset:(urn:li:dataPlatform:tableau,06c3e060-8133-4b58-9b53-a0fced25e056,PROD)']
This will delete 12 entities. Are you sure? [y/N]: y
100% (12 of 12) |###################################################################################################################################################################| Elapsed Time: 0:00:00 Time:  0:00:00
Took 5.455 seconds to soft delete -1 rows for 12 entities
❯ datahub delete --entity_type container --platform tableau
[2022-05-02 22:38:49,641] INFO     {datahub.cli.delete_cli:209} - datahub configured with <http://localhost:8080>
[2022-05-02 22:38:49,738] INFO     {datahub.cli.delete_cli:222} - Filter matched 4 entities. Sample: ['urn:li:container:94e6e84b66f9ee8c70c22f06cfbad6a9', 'urn:li:container:047691e9c16bec8fb08e1df0f5d71c4d', 'urn:li:container:008e111aa1d250dd52e0fd5d4b307b1a', 'urn:li:container:94e6e84b66f9ee8c70c22f06cfbad6a9']
This will delete 4 entities. Are you sure? [y/N]: y
100% (4 of 4) |#####################################################################################################################################################################| Elapsed Time: 0:00:00 Time:  0:00:00
Took 2.284 seconds to soft delete -1 rows for 4 entities

4 Views

Open in Slack

Previous Next