Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-10374

Recover and load SDSS PDAC metadata

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: dax, metaserv
    • Labels:
      None

      Description

      The current PDAC tables in QServ do not have associated metadata with them. That metadata should be recovered, and add schema to lsst/cat project, as well as the schema in https://github.com/lsst-dm/db_pdac_stripe82.

        Attachments

          Issue Links

            Activity

            Hide
            bvan Brian Van Klaveren added a comment -

            Work needs to be performed to fix the schema parser as well. That work is actually captured in DM-10375.

            Show
            bvan Brian Van Klaveren added a comment - Work needs to be performed to fix the schema parser as well. That work is actually captured in DM-10375 .
            Hide
            bvan Brian Van Klaveren added a comment -

            Hi Andy,

            This was parseable by the metaserv parser, so I think it should be fine for the cat scripts, but I'm not sure how the view stuff is supposed to work. That said, I can remove the views.

            I'm also missing the indexes, but that's a different issue.

            Show
            bvan Brian Van Klaveren added a comment - Hi Andy, This was parseable by the metaserv parser, so I think it should be fine for the cat scripts, but I'm not sure how the view stuff is supposed to work. That said, I can remove the views. I'm also missing the indexes, but that's a different issue.
            Hide
            salnikov Andy Salnikov added a comment -

            Looks OK, comments on PR.

            Show
            salnikov Andy Salnikov added a comment - Looks OK, comments on PR.
            Hide
            salnikov Andy Salnikov added a comment -

            And I'm not sure about view definition, to me it seems it does not matter, and it's commented. Igor Gaponenko, is DeepSource view need there?

            Show
            salnikov Andy Salnikov added a comment - And I'm not sure about view definition, to me it seems it does not matter, and it's commented. Igor Gaponenko , is DeepSource view need there?
            Hide
            gapon Igor Gaponenko added a comment -

            Andy Salnikov I'm not sure if anyone needs that view. I have it in the catalog for the sake of compatibility with the original Summer 2013 Data Challenge exercise. Just in case.

            Show
            gapon Igor Gaponenko added a comment - Andy Salnikov I'm not sure if anyone needs that view. I have it in the catalog for the sake of compatibility with the original Summer 2013 Data Challenge exercise. Just in case.
            Hide
            bvan Brian Van Klaveren added a comment -

            New issue to cleanup this is created.

            Show
            bvan Brian Van Klaveren added a comment - New issue to cleanup this is created.

              People

              Assignee:
              bvan Brian Van Klaveren
              Reporter:
              bvan Brian Van Klaveren
              Reviewers:
              Andy Salnikov
              Watchers:
              Andy Salnikov, Brian Van Klaveren, Igor Gaponenko
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: