Hi all, I'm trying to ingest from Tableau server `...
# ingestion
l
Hi all, I'm trying to ingest from Tableau server
datahub ingest -c 'C:\Users\matt.evans\.datahub\tableau\tableau.dhub.yaml' --dry-run
but am getting the following error
Copy code
File "C:\Users\matt.evans\AppData\Local\Programs\Python\Python310\lib\site-packages\datahub\configuration\config_loader.py", line 101, in load_config_file
    raise ConfigurationError(
datahub.configuration.common.ConfigurationError: Cannot read remote file C:\Users\matt.evans\.datahub\tableau\tableau.dhub.yaml, error:No connection adapters were found for 'C:\\Users\\matt.evans\\.datahub\\tableau\\tableau.dhub.yaml'
Any idea what I'm doing wrong? Seems to be something in the yaml file it doesn't like.
l
Hey there πŸ‘‹ I'm The DataHub Community Support bot. I'm here to help make sure the community can best support you with your request. Let's double check a few things first: 1️⃣ There's a lot of good information on our docs site: www.datahubproject.io/docs, Have you searched there for a solution? Yes button βœ… It's not uncommon that someone has run into your exact problem before in the community. Have you searched Slack for similar issues? βœ… button
l
no
Windows 10 DataHub CLI version: 0.10.2.1 Python version: 3.10.0 (tags/v3.10.0:b494f59, Oct 4 2021, 190018) [MSC v.1929 64 bit (AMD64)]
h
Could you please use latest RC version -
pip install acryl-datahub==0.10.2.3rc7
or older cli version
pip install acryl-datahub==v0.10.1
This is same issue as was the root cause here
l
@hundreds-photographer-13496 0.10.2.3rc7 - gives the error
Failed to find a registered source for type tableau: 'str' object is not callable
0.10.1 - seems to work better but keeps saying my token has expired. I don't think this is the case as it's a new token, i have also regenerated it several times and the user has the correct permissions. Could it be there's a problem with my yaml file? In particular i see some examples online where strings are in quotes and some without. What is the correct way to add the token to the yaml file? output
Copy code
←[32m←[2m[2023-05-12 09:46:10,287]←[0m INFO    ←[0m ←[34m←[2m{datahub.cli.ingest_cli:173}←[0m - DataHub CLI version: 0.10.1←[0m
←[32m←[2m[2023-05-12 09:46:10,342]←[0m INFO    ←[0m ←[34m←[2m{datahub.ingestion.run.pipeline:184}←[0m - Sink configured successfully. ←[0m
←[32m←[2m[2023-05-12 09:46:10,781]←[0m INFO    ←[0m ←[34m←[2m{TSC.server:179}←[0m - versions: 3.19, 2.4←[0m
←[32m←[2m[2023-05-12 09:46:10,839]←[0m INFO    ←[0m ←[34m←[2m{datahub.ingestion.source.tableau:220}←[0m - Error authenticating with Tableau. Note that Tableau personal access tokens expire if not used for 15 days or if over 1 year old←[0m
←[32m←[2m[2023-05-12 09:46:10,839]←[0m INFO    ←[0m ←[34m←[2m{datahub.ingestion.run.pipeline:201}←[0m - Source configured successfully.←[0m
←[32m←[2m[2023-05-12 09:46:10,849]←[0m INFO    ←[0m ←[34m←[2m{datahub.cli.ingest_cli:129}←[0m - Starting metadata ingestion←[0m
-←[32m←[2m[2023-05-12 09:46:10,850]←[0m INFO    ←[0m ←[34m←[2m{datahub.cli.ingest_cli:142}←[0m - Finished metadata ingestion←[0m
/
Cli report:
{'cli_version': '0.10.1',
 'cli_entry_location': 'C:\\Users\\matt.evans\\AppData\\Local\\Programs\\Python\\Python310\\lib\\site-packages\\datahub\\__init__.py',
 'py_version': '3.10.0 (tags/v3.10.0:b494f59, Oct  4 2021, 19:00:18) [MSC v.1929 64 bit (AMD64)]',
 'py_exec_path': 'C:\\Users\\matt.evans\\AppData\\Local\\Programs\\Python\\Python310\\python.exe',
 'os_details': 'Windows-10-10.0.19045-SP0',
 'peak_memory_usage': '65.28 MB',
 'mem_info': '65.28 MB'}
Source (tableau) report:
{'events_produced': 0,
 'events_produced_per_sec': 0,
 'entities': {},
 'aspects': {},
 'warnings': {},
 'failures': {'tableau-login': ['Unable to login (invalid/expired credentials or missing permissions): \n\n\t401001: Signin Error\n\t\tThe personal access token you provided is invalid.']},
 'soft_deleted_stale_entities': [],
 'start_time': '2023-05-12 09:46:10.587409 (now)',
 'running_time': '0.6 seconds'}
Sink (file) report:
{'total_records_written': 0,
 'records_written_per_second': 0,
 'warnings': [],
 'failures': [],
 'start_time': '2023-05-12 09:46:10.340383 (now)',
 'current_time': '2023-05-12 09:46:11.187892 (now)',
 'total_duration_in_seconds': 0.85}

 Pipeline finished with at least 1 failures; produced 0 events in 0.6 seconds.
a
0.10.2.3rc7 - gives the error
Failed to find a registered source for type tableau: 'str' object is not callable
that's quite odd. Can you please try using the latest datahub version if this is still the case -
pip install acryl-datahub==0.10.2.3
0.10.1 - seems to work better but keeps saying my token has expired.
How did you generate the token. Did you follow the steps as mentioned here - https://help.tableau.com/current/pro/desktop/en-us/useracct.htm#create-and-revoke-personal-access-tokens I would also request you to double check if you are using the correct "site".