I am running on VM SSH server on Google cloud. i have a problem airflow is failing to connect to GCP, I followed an answers which someone did do and it helps for him but for me the process is not helping me, here is the error and this are what i did, i first download the cred used sftp to send the credentials to GCP because am running on GOOGLE VM SSH, and connect to airflow but if fails and export the airflow_con_default that didn't work even using the credentials file path to connect with gcp credential but it didn't work, this are my errors.. also tried to connect with airflow admin UI with credentials still give me same error, please what do i need to do"""
"/.google/credentials/key.json/:google_credentials.json:ro",mount in volume export AIRFLOW_CONN_GOOGLE_CLOUD_DEFAULT=key.path.json all this didn't work also. Thanks in advance for taking time to help, really appreciate that. Happy Sunday **
Traceback (most recent call last): File "/home/airflow/.local/lib/python3.7/site-packages/airflow/providers/google/cloud/transfers/gcs_to_bigquery.py", line 370, in execute
default_project_id=self.hook.project_id or "", File "/home/airflow/.local/lib/python3.7/site-packages/airflow/providers/google/common/hooks/base_google.py", line 342, in project_id
_, project_id = self.get_credentials_and_project_id() File "/home/airflow/.local/lib/python3.7/site-packages/airflow/providers/google/common/hooks/base_google.py", line 261, in get_credentials_and_project_id
delegates=delegates, File "/home/airflow/.local/lib/python3.7/site-packages/airflow/providers/google/cloud/utils/credentials_provider.py", line 332, in get_credentials_and_project_id
return _CredentialProvider(*args, **kwargs).get_credentials_and_project() File "/home/airflow/.local/lib/python3.7/site-packages/airflow/providers/google/cloud/utils/credentials_provider.py", line 231, in get_credentials_and_project
credentials, project_id = self._get_credentials_using_key_path() File "/home/airflow/.local/lib/python3.7/site-packages/airflow/providers/google/cloud/utils/credentials_provider.py", line 281, in _get_credentials_using_key_path
self.key_path, scopes=self.scopes File "/home/airflow/.local/lib/python3.7/site-packages/google/oauth2/service_account.py", line 242, in from_service_account_file
filename, require=["client_email", "token_uri"] File "/home/airflow/.local/lib/python3.7/site-packages/google/auth/_service_account_info.py", line 79, in from_filename
with io.open(filename, "r", encoding="utf-8") as json_file: FileNotFoundError: [Errno 2] No such file or directory: '/.google/credentials/google_credentials.json' [2023-02-05, 06:41:38 UTC] {taskinstance.py:1327} INFO - Marking task as FAILED. dag_id=LocalInjestionDag, task_id=loading_dataset_to_bq, execution_date=20230102T060000, start_date=20230205T064137, end_date=20230205T064138 [2023-02-05, 06:41:38 UTC] {standard_task_runner.py:105} ERROR - Failed to execute job 332 for task loading_dataset_to_bq ([Errno 2] No such file or directory: '/.google/credentials/google_credentials.json'; 692) [2023-02-05, 06:41:38 UTC] {local_task_job.py:159} INFO - Task exited with return code 1 [2023-02-05, 06:53:01 UTC] {taskinstance.py:1087} INFO - Dependencies all met for <TaskInstance: LocalInjestionDag.loading_dataset_to_bq scheduled__2023-01-02T06:00:00+00:00 [queued]> [2023-02-05, 06:53:01 UTC] {taskinstance.py:1087} INFO - Dependencies all met for <TaskInstance: LocalInjestionDag.loading_dataset_to_bq scheduled__2023-01-02T06:00:00+00:00 [queued]> [2023-02-05, 06:53:01 UTC] {taskinstance.py:1283} INFO -
**
