https://prefect.io logo
Title
n

Nitin Bansal

05/23/2023, 9:04 AM
I have started using prefect-sqlalchemy but getting following error while establishing connection with Postgres using following command
def setdatabaseconnection():
    connector = SqlAlchemyConnector(
        connection_info=ConnectionComponents(
            driver=SyncDriver.POSTGRESQL_PSYCOPG2,
            username="postgres",
            password="",
            host="localhost",
            port=5432,
            database="claimshero_dev",
        )
    )

    connector.save("CH_DATABASE_CONNECTION")
Error : pydantic.error_wrappers.ValidationError: 2 validation errors for BlockDocumentCreate name name must only contain lowercase letters, numbers, and dashes (type=value_error) root Names must be provided for block documents. (type=value_error)
j

Jake Kaplan

05/23/2023, 1:48 PM
hi! Can you try changing:
connector.save("CH_DATABASE_CONNECTION")
to
connector.save("ch-database-connection")
n

Nitin Bansal

05/24/2023, 11:13 AM
Thanks @Jake Kaplan One more question, We are using WaitOnContainer from prefect.tasks.docker in Prefect 1, to wait for a container until it finish its work. In Prefect 2 we use prefect_docker.containers but, it doesn't have function to wait for a container to finish its work. Is this functionality not implemented in Prefect 2.0? Any workaround?