CSV Upload Model Join with database

Hi there,

I've uploaded a model to csv in a collection and I'm trying to join it with my database. However, it seems like when I select the model in a question, it only shows the Sample Database for joining.

Is there a way I can join the csv model with my own database?

This is what I see when trying to join it with a saved question

Also I'm seeing this error on a csv model I've used previously with ease. Is there any issues going on/bugs reported around this..?

Hello farhan,

It seem to be an idiot question but are you sure that our own database is correctly plug to Metabase ? Have you done some other requests on the database ?

yeap yeap - nothing's broken at any end in that regards - the db is in use everyday

Are you storing the CSV in your own database?

I'm uploading the csv in a collection - that collection has questions from the same database. Does that help?

Or is there an admin setting where I can configure which database does a csv upload to by default?

You need to upload your CSVs to the same database. If you are seeing only the Sample Database, that's because you're uploading CSVs to your Sample DB.

1 Like

Yes that's perfect. Thank you for your patience .

That works for new files but I'm running into an issue where the old csv models stop loading in the query builder

Like this model was working perfectly fine today and now it's broken now. Any idea what might be causing that?

If you uploaded these CSVs to the sample database, there is a high chance they were deleted. The sample database is an in-memory DB that gets cleaned when the instance restarts.

There is a big warning when you select the sample database as the upload target db.

2 Likes