MySQL - Artie

Required settings

Host name
Port (default is 3306)
Service account

Creating a service account

-- Create the service account
CREATE USER 'artie' IDENTIFIED BY 'password';

-- Grant the necessary permissions to the service account for us to merge data and manage schema evolution.
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON *.* TO 'artie';

PostgreSQLLearn how to configure PostgreSQL as a destination in Artie, including host and port settings, service account creation, schema ownership, and the required database permissions.

⌘I