'Attach csv file to mariadb

Is it possible to access a csv file directly with the csv storage engine without going through the trouble of loading it first? We deploy a data warehouse where during load CSV files are read into a temp table and then insert the content in production fact tables. I wonder if we could just pass the load into and "directly go to jail insert"?

mariadbdata-warehouse


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

Does Primary key in Dimension table have to be part of the Primary key in the Fact table?

Data warehouse design for parking lot - date and time dimensions

ECLAT Algorithm to find maximal and closed frequent sets

Distinct aggregation in pre-calculated measure (MDX)

Redshift design or configuration issue? - My Redshift datawarehouse seems much slower than my mysql database

A simple left join query taking lot of time for output

Data warehouse, could a dimention be a fact?

SCD Start and End Date

ClickHouse TTL settings with WHERE condition

SCD2 on nested table in GCP big query

Pentaho spoon search and replace especial character in rows

Pentaho spoon search and replace especial character in rows

MariaDB - Cannot connect to MariaDB instance from Dbeaver using correct password

Debian 10 MariaDB 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

Get full tree of parent/child relationships in mysql of any node in the tree with all parents