Hi Team, How to delete all tables from datasource ...
# troubleshoot
n
Hi Team, How to delete all tables from datasource in datahub?
g
n
Where to find the urn?
g
datahub delete --env DEV --entity_type dataset
this command will delete all in
dev
environment. depends on your configuration
n
There is no env set I need to delete all the oracle data Where to get the arn for that?
g
datahub delete --entity_type container --platform oracle
? how about this? you can get the
urn
in the URL. go to the UI and click one dataset from oracle, you can see the platform and env.
n
Failed to connect to DataHub server at http://localhost:8080 Getting this error
g
ah, where do u run your datahub? local or cloud?
n
cloud deployed on kubernetes
g
GMS url.
n
I am not giving the gms url anywhere Using this command: datahub delete --urn "lidataPlatformoracle" --hard
g
try find this file
.datahubenv
Copy code
gms:
  server: <https://datahub_cloud_url:8080>
  token: null
server:
should be your datahub url, cannot localhost
n
No file present of that name
g
no, it should present when you run start datahub in your local. i believe you already install datahub env in your local. then, you run delete command in your local. am i right?
n
I have deployed datahub on redhat openshift cluster.
g
where you run this?
datahub delete --urn "li:dataPlatform:oracle" --hard
n
I have tried running this in acryl pod, gms pod and local also
g
ok, do one thing
Copy code
python3 -m pip install --upgrade pip wheel setuptools
python3 -m pip uninstall datahub acryl-datahub || true  # sanity check - ok if it fails
python3 -m pip install --upgrade acryl-datahub
datahub version
run this in your local, inDocuments folder should be fine
install python and create py-enviroment
n
Yes I have done that what next?
g
open any IDE, and find
.datahubenv
should appear in Documents
n
no it is not there
g
weird.. maybe try to locate in whole directory.
it must be somewhere, if not how the command know current DataHub server configure at
<http://localhost:8080>
based on your error message
n
Yes I tried searching in the whole directory, Is there any other way to delete the datasets?
g
ah, not sure the other ways mate. 😞
i
@numerous-account-62719 please create the
.datahubenv
in your home directory
In that file you specify the datahhub url
Create it under
~/.datahubenv
The content should be:
Copy code
gms:
  server: http://<datahub frontend url>:8080