Should I know about PRAGMA already?

Q&A DQ Courses
, ,
#1

Hello,

Slightly confused and looking for some clarification please. The first screen of this mission requires the use of a PRAGMA TABLE_INFO query, but I don’t recall this SQLite extension being covered in any of the previous SQL missions/courses on the Data Science in Python track. The screen hint and answer suggests that I should have been formally taught about PRAGMA queries already.

Have I missed/forgotten something? Could this be a potential teaching gap in this DS track?

7 Likes
#2

I was in the same boat and didn’t know what pragma did.

2 Likes
#3

Same here, perhaps we should report it to DQ’s team.

1 Like
#4

Hi @ajlaan, @alp.f.alptekin, @gabriel.belle,

Thank you for pointing this out. We had this information available in our previous course on SQL. Probably the content on PRAGMA got skipped during rewrite. I will get it logged.

Best,
Sahil

1 Like