Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2970

Set default MatView Extension Properties for JDG materialization

    XMLWordPrintable

Details

    Description

      When a view is being materialized for JDG, set the following extension properties:

      teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT -

         execute {jdgsourcemodelname}.native(''swap cache names'');
      

      teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT -

        execute {jdgsourcemodelname}.native(''truncate cache'');
      

      teiid_rel:MATERIALIZED_STAGE_TABLE -

       
        {jdgsourcemodelname}.{stagingTable}
      

      where

      {jdgsourcemodelname}

      as the new JDG Source Model that is created.

      note: do not add tic's around these, like 'execute......),'
      but do add the double tic's inside the native call

      Attachments

        Activity

          People

            blafond Barry LaFond
            van.halbert Van Halbert (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: