C2-W3 Graded Assignment: Could not able to find MYSQL_CONNECTION_STRING

Course Q&A Data Engineering Source Systems, Data Ingestion, and Pipelines
,
1

I am currently trying to finish the C2 W3 graded assignment.
Testing Data Quality with Great Expectations.

I am unable to create the data source based on the instructions given.

The instruction state to create an variable MYSQL_CONNECTION_STRING in the uncommited/config_variables.yml file with the connection string we get from running scripts.sh.

I have appended the same in that file below the instance id.

When I try to create the mysql_datasource object it is stating the following error.

image
image1466×241 13.9 KB

From the above error there is an issue with fetching the data from this config_variable.yml file. I have tried to do few fixes but could not able to do anything beyond this point.

Kindly provide an resolution on this.

2

Hello @Narendrans13,
Could you try deleting config file and great_expectations.yml then run great_expectation init again. That way you will start fresh and be able to create a new data source with the same name. Hope it helps

3

Hi @Georgios . Thanks for the suggestion. I have removed the config and great_expectation.yml files and rerun the init.

I can able to finish the assignment.

Thanks for your help

1 Like