Meltano

<@U06C8PJF0TF> Do you have an example of what a meltano.yml may look like for using Azure blob storage as state back end? Is it as simple as setting the state_backend uri to your container and then the connection string as an env var? What setup is required on the azure side?

Yes in my container I set these as env vars

`MELTANO_STATE_BACKEND_AZURE_CONNECTION_STRING` = `DefaultEndpointsProtocol=https;Account.....`

name: 'MELTANO_STATE_BACKEND_URI'
    value: '<azure://meltano-state>'

On the Azure portal, set up a storage account, copy the connection string, I think that's it :slightly_smiling_face:

I deliberately don't set anything in `meltano.yml` because I don't want any local work to potentially affect state store in dev/prod in the cloud. So locally, by not setting the two env vars above, I default to use the standard sqlite.