2023/06/05 19:24

Error

ERROR: An error occurred when attempting to create the SqlClient

metricflow.errors.errors.SqlClientCreationException: An error occurred when attempting to create the SqlClient

Solution

In my case, it was caused by using the ellipsis tillipsis “~” in the HOME directory for the dwh_path_to_creds value in the config.yml file.
I was able to connect by specifying the full path like “/Users/y-tsuzaki/” instead of “~”.

– dwh_path_to_creds: ~/.metricflow/my_gcp_service_account.json # Provide the path to the BigQuery credential file, ignore to use ADC auth

+ dwh_path_to_creds: /Users/y-tsuzaki/.metricflow/my_gcp_service_account.json # Provide the path to the BigQuery credential file, ignore to use ADC auth