Query Error: "relation 'decaps_dr1.meas' does not exist" in Astrolab Jupyter Notebook

Question

Hello,

I'm encountering an error when trying to run a query in the NOIRLAB Astrolab Jupyter notebook environment. When I execute the following query: 

query2 = """ SELECT *

        FROM decaps_dr1.meas

        LIMIT 100000"""
df2 = qc.query(sql=query2, fmt='pandas')

When I try to run the query, it returns a queryClientError: "Error: relation 'decaps_dr1.meas' does not exist". This is particularly confusing because I'm able to look at the schema via qc.schema('decaps_dr1.meas', format='json') without any errors.

Thank you in advance for any help!

Cheers,
Andy

Answer 1

Hi, thank you for reaching out and bringing this to our attention.

We goofed here: the decaps_dr1.meas table was being prepared for ingestion a while ago, and we had the metadata loaded up (hence you could see the table with qc.schema()), but the table itself wasn't ready at the time to be loaded into the database, and then slipped through the cracks.

We will add the table to the database shortly, but I can't give an ETA yet. In the meantime, we have removed the table metadata so that at least the confusion/mismatch is resolved.

We apologize for causing the confusion.