In T312799, we are doing a POC of connecting our Airflow infrastructure to a MariaDB instance on one of the misc servers.
Ask:
Create schema "image_suggestions". Create user xcollazo. Grant ALL to user xcollazo under this new schema. Provide us connection details.
Purpose:
We want to create some dummy tables under this "image_suggestions" schema to prove that we can access it from our Airflow infrastructure.
Sample DDL and data:
CREATE TABLE IF NOT EXISTS test (
id INT AUTO_INCREMENT PRIMARY KEY,
content VARCHAR(255) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
INSERT INTO test(content) VALUES ("hello"), ("world");If the POC is successful, we would want to drop all the dummy tables and repurpose the schema to create a set of tables that would provide state for an app, but this is far in the future, and we don't know the DDL for the app yet. We would of course let you know before we move forward with that.