Module # must be added in the tags option of the post. (ex: Module-1)
Link to the classroom item you are referring to:
Description (include relevant info but please do not post solution code or your entire notebook)
after making configuraation to file great_expectations.yml, the context gives me this message
Something went wrong when trying to use SQLAlchemy to obfuscate URL: Could not parse SQLAlchemy URL from string ‘{MYSQL_CONNECTION_STRING}' Something went wrong when trying to use SQLAlchemy to obfuscate URL: Could not parse SQLAlchemy URL from string '{MYSQL_CONNECTION_STRING}’ Something went wrong when trying to use SQLAlchemy to obfuscate URL: Could not parse SQLAlchemy URL from string ‘{MYSQL_CONNECTION_STRING}' Something went wrong when trying to use SQLAlchemy to obfuscate URL: Could not parse SQLAlchemy URL from string '{MYSQL_CONNECTION_STRING}’
after running check_result = checkpoint.run()
how would I restart the lab to start from zero.
how do I restart this lab to start again all over from 0 can someone help thanks
Alejandro
You could delete config_variables.ymland great_expectations.yml files and run great_expectations init command to recreate those files.
Afterwards replace the placeholders in great_expectations.yml file and add MYSQL_CONNECTION_STRING in the config_variables.yml. Finally run great_expectations store list command again. That will allow you to create a new data source and start from the beginning. Thank you
I kind of fixed those files but I got a message when I run the context. It is not an error message but a misconfiguration this is the message Something went wrong when trying to use SQLAlchemy to obfuscate URL: Could not parse SQLAlchemy URL from string ‘{MYSQL_CONNECTION_STRING}' Something went wrong when trying to use SQLAlchemy to obfuscate URL: Could not parse SQLAlchemy URL from string '{MYSQL_CONNECTION_STRING}’ Something went wrong when trying to use SQLAlchemy to obfuscate URL: Could not parse SQLAlchemy URL from string ‘{MYSQL_CONNECTION_STRING}' Something went wrong when trying to use SQLAlchemy to obfuscate URL: Could not parse SQLAlchemy URL from string '{MYSQL_CONNECTION_STRING}’ Something went wrong when trying to use SQLAlchemy to obfuscate URL: Could not parse SQLAlchemy URL from string ‘{MYSQL_CONNECTION_STRING}' Something went wrong when trying to use SQLAlchemy to obfuscate URL: Could not parse SQLAlchemy URL from string '{MYSQL_CONNECTION_STRING}’ Something went wrong when trying to use SQLAlchemy to obfuscate URL: Could not parse SQLAlchemy URL from string ‘{MYSQL_CONNECTION_STRING}' Something went wrong when trying to use SQLAlchemy to obfuscate URL: Could not parse SQLAlchemy URL from string '{MYSQL_CONNECTION_STRING}’
I am not sure you if you can edit those files, even if you Add a new MYSQL_CONNECTION_STRING into config_variables.yml it has the old instance_id. I suggest going from the beginning and recreate those files from scratch with great_expectations init after you delete those files. Only keep a copy of great_expectations.yml so you can just replace the bucket names in the placeholders. After that you should be able to run great_expectations store list command again and run the context. Thank you
I understand, thank you for help Georgios, I got to fixed but when I opened the lab again and I ran again great_expectation init I got again into the problem. I want to ask you the instant id must be changed every time I run great_expectation init ?
Also, after I fixed the context problem. I run into another problem which is the checkpoing_result = checkpoin.run() when I run this command I get this message
Yes there is an issue with great_expectations.yml file when you replaced placeholders. You need to delete config_variables.yml and great_expectations.yml file as well and start from scratch. When you run great _expectations init you will recreate those files.
Finally run great_expectations store list command again and you should be able able to continue. Thank you
I understand Georgios, However, is there a possibility where I can restart the lab again. i want to start all over again because I deleted an important file by mistake trying to delete great_expectations.yml. I deleted the main file where the commands are runned Thank you very much for the help you are the best
I dn’t think you can reset the Coursera lab after you edited the files. You could get any file you deleted back with get latest version. You will find it in the top right corner under help. You can even rename any files you want and create a new folder e.g. old_copy .Then keep your old files as a backup and get latest version will update with new files. Hope it helps
