Comments

8 comments

  • Official comment
    Avatar
    Franck Reyherme

     

    Roger that. In that case, the interim assessment blocks are in the exact same table as your summative casspp data. To hone in on those interim assessment blocks, you’ll need to filter by assessment type. Here’s an example:

    SELECT *
    FROM state_data_ca.caaspp_2018_ela
    WHERE "caaspp_2018_assessType" = 'INTERIM ASSESSMENT BLOCKS'
    

    Does that help?

  • Avatar
    Franck Reyherme

    Hi Margarita,

     

    Are you using SQL or custom reporting?

  • Avatar
    Margarita Rodriguez

    Hi Franck!  I'm using SQL

  • Avatar
    Margarita Rodriguez

    Immensely!  Thank you Franck, you are my hero

     

     

  • Avatar
    Franck Reyherme

    Happy to help!

  • Avatar
    Margarita Rodriguez

    Franck, 

    It appears 2018 tables has data for SY 17-18 but when I use 2019 i get this weird permission error

     

  • Avatar
    Franck Reyherme

    That's totally normal.  All that means is your ODBC credentials/permissions were created before the 2019 tables were created.  When your ODBC credentials are created, we give you access to all existing tables, but when new tables are created (as they are every year for new years of state data), if you want to access these new tables, you'll have to submit a help ticket requesting that we refresh your credentials.  

    I know this is inconvenient, but it ensures the highest level of security for the sensitive data in your Illuminate database.  

    Please send an email to help@illuminateed.com asking us to refresh your ODBC credentials/permissions.  Feel free to CC me on the email.  We will refresh your ODBC access and then you'll have access to these tables as well!

  • Avatar
    Margarita Rodriguez

    Thank you Franck.  You rock!

Please sign in to leave a comment.