> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# kinetica.CreateMaterializedViewRequest

> kinetica.CreateMaterializedViewRequest — Kinetica C# API

<div className="kinetica-doxygen">
  <div className="contents">
    <p>A set of parameters for <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica/creatematerializedview#afbec7be04cf88d679d4d0092e264cf13">Kinetica.createMaterializedView</a>. <a href="#details">More...</a></p>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader">
            <div id="nested-classes" />

            Classes
          </h2>
        </td>
      </tr>

      <tr className="memitem:">
        <td className="memItemLeft" align="right" valign="top">struct  </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options">Options</a></td>
      </tr>

      <tr className="memdesc:">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">A set of string constants for the parameter <a className="el" href="#a260d6cd873e362adc49cf04a45d8351d" title="Optional parameters.">CreateMaterializedViewRequest.options</a>. <a href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#details">More...</a><br /></td>
      </tr>

      <tr className="separator:">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader">
            <div id="pub-methods" />

            Public Member Functions
          </h2>
        </td>
      </tr>

      <tr className="memitem:ab6c74daf528e3ba9b7ccb7a34d805a3f" id="r_ab6c74daf528e3ba9b7ccb7a34d805a3f">
        <td className="memItemLeft" align="right" valign="top"> </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ab6c74daf528e3ba9b7ccb7a34d805a3f">CreateMaterializedViewRequest</a> ()</td>
      </tr>

      <tr className="memdesc:ab6c74daf528e3ba9b7ccb7a34d805a3f">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Constructs a <a className="el" href="/content/api/cs/classkinetica_1_1CreateMaterializedViewRequest" title="A set of parameters for Kinetica.createMaterializedView.">CreateMaterializedViewRequest</a> object with default parameters. <br /></td>
      </tr>

      <tr className="separator:ab6c74daf528e3ba9b7ccb7a34d805a3f">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a75838dba69a53e66516ea64aeb130a47" id="r_a75838dba69a53e66516ea64aeb130a47">
        <td className="memItemLeft" align="right" valign="top"> </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a75838dba69a53e66516ea64aeb130a47">CreateMaterializedViewRequest</a> (string <a className="el" href="#ae4efb251be00e32b046b0111d659db9f">table\_name</a>, IDictionary\< string, string > <a className="el" href="#a260d6cd873e362adc49cf04a45d8351d">options</a>=null)</td>
      </tr>

      <tr className="memdesc:a75838dba69a53e66516ea64aeb130a47">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Constructs a <a className="el" href="/content/api/cs/classkinetica_1_1CreateMaterializedViewRequest" title="A set of parameters for Kinetica.createMaterializedView.">CreateMaterializedViewRequest</a> object with the specified parameters. <br /></td>
      </tr>

      <tr className="separator:a75838dba69a53e66516ea64aeb130a47">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="inherit_header pub_methods_classkinetica_1_1KineticaData">
        <td colSpan="2"> Public Member Functions inherited from <a className="el" href="/content/api/cs/classkinetica_1_1KineticaData">kinetica.KineticaData</a></td>
      </tr>

      <tr className="memitem:a6a494237f126f79a7f478b7614323482 inherit pub_methods_classkinetica_1_1KineticaData" id="r_a6a494237f126f79a7f478b7614323482">
        <td className="memItemLeft" align="right" valign="top"> </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="/content/api/cs/classkinetica_1_1KineticaData#a6a494237f126f79a7f478b7614323482">KineticaData</a> (<a className="el" href="/content/api/cs/classkinetica_1_1KineticaType">KineticaType</a> type)</td>
      </tr>

      <tr className="memdesc:a6a494237f126f79a7f478b7614323482 inherit pub_methods_classkinetica_1_1KineticaData">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Constructor from <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica" title="API to talk to Kinetica Database.">Kinetica</a> Type. <br /></td>
      </tr>

      <tr className="separator:a6a494237f126f79a7f478b7614323482 inherit pub_methods_classkinetica_1_1KineticaData">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ac8cbdce08f2dd7d0d02bf0f279d79b79 inherit pub_methods_classkinetica_1_1KineticaData" id="r_ac8cbdce08f2dd7d0d02bf0f279d79b79">
        <td className="memItemLeft" align="right" valign="top"> </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="/content/api/cs/classkinetica_1_1KineticaData#ac8cbdce08f2dd7d0d02bf0f279d79b79">KineticaData</a> (System.Type type=null)</td>
      </tr>

      <tr className="memdesc:ac8cbdce08f2dd7d0d02bf0f279d79b79 inherit pub_methods_classkinetica_1_1KineticaData">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Default constructor, with optional System.Type. <br /></td>
      </tr>

      <tr className="separator:ac8cbdce08f2dd7d0d02bf0f279d79b79 inherit pub_methods_classkinetica_1_1KineticaData">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a8fceb0fc6b641ef28b7548bc2820e48f inherit pub_methods_classkinetica_1_1KineticaData" id="r_a8fceb0fc6b641ef28b7548bc2820e48f">
        <td className="memItemLeft" align="right" valign="top">object </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="/content/api/cs/classkinetica_1_1KineticaData#a8fceb0fc6b641ef28b7548bc2820e48f">Get</a> (int fieldPos)</td>
      </tr>

      <tr className="memdesc:a8fceb0fc6b641ef28b7548bc2820e48f inherit pub_methods_classkinetica_1_1KineticaData">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Retrieve a specific property from this object. <br /></td>
      </tr>

      <tr className="separator:a8fceb0fc6b641ef28b7548bc2820e48f inherit pub_methods_classkinetica_1_1KineticaData">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ad02b0bac0aa3f8a64b0ec46a94bd06f0 inherit pub_methods_classkinetica_1_1KineticaData" id="r_ad02b0bac0aa3f8a64b0ec46a94bd06f0">
        <td className="memItemLeft" align="right" valign="top">void </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="/content/api/cs/classkinetica_1_1KineticaData#ad02b0bac0aa3f8a64b0ec46a94bd06f0">Put</a> (int fieldPos, object fieldValue)</td>
      </tr>

      <tr className="memdesc:ad02b0bac0aa3f8a64b0ec46a94bd06f0 inherit pub_methods_classkinetica_1_1KineticaData">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Write a specific property to this object. <br /></td>
      </tr>

      <tr className="separator:ad02b0bac0aa3f8a64b0ec46a94bd06f0 inherit pub_methods_classkinetica_1_1KineticaData">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader">
            <div id="properties" />

            Properties
          </h2>
        </td>
      </tr>

      <tr className="memitem:ae4efb251be00e32b046b0111d659db9f" id="r_ae4efb251be00e32b046b0111d659db9f">
        <td className="memItemLeft" align="right" valign="top">string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ae4efb251be00e32b046b0111d659db9f">table\_name</a><code> \[get, set]</code></td>
      </tr>

      <tr className="memdesc:ae4efb251be00e32b046b0111d659db9f">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Name of the table to be created that is the top-level table of the materialized view, in \[schema\_name. <br /></td>
      </tr>

      <tr className="separator:ae4efb251be00e32b046b0111d659db9f">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a260d6cd873e362adc49cf04a45d8351d" id="r_a260d6cd873e362adc49cf04a45d8351d">
        <td className="memItemLeft" align="right" valign="top">IDictionary\< string, string > </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a260d6cd873e362adc49cf04a45d8351d">options</a> = new Dictionary\<string, string>()<code> \[get, set]</code></td>
      </tr>

      <tr className="memdesc:a260d6cd873e362adc49cf04a45d8351d">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Optional parameters. <br /></td>
      </tr>

      <tr className="separator:a260d6cd873e362adc49cf04a45d8351d">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="inherit_header properties_classkinetica_1_1KineticaData">
        <td colSpan="2"> Properties inherited from <a className="el" href="/content/api/cs/classkinetica_1_1KineticaData">kinetica.KineticaData</a></td>
      </tr>

      <tr className="memitem:ae35f20177341ed020cb1c92195621499 inherit properties_classkinetica_1_1KineticaData" id="r_ae35f20177341ed020cb1c92195621499">
        <td className="memItemLeft" align="right" valign="top">Schema </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="/content/api/cs/classkinetica_1_1KineticaData#ae35f20177341ed020cb1c92195621499">Schema</a><code> \[get]</code></td>
      </tr>

      <tr className="memdesc:ae35f20177341ed020cb1c92195621499 inherit properties_classkinetica_1_1KineticaData">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Avro Schema for this class. <br /></td>
      </tr>

      <tr className="separator:ae35f20177341ed020cb1c92195621499 inherit properties_classkinetica_1_1KineticaData">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader">
            <div id="inherited" />

            Additional Inherited Members
          </h2>
        </td>
      </tr>

      <tr className="inherit_header pub_static_methods_classkinetica_1_1KineticaData">
        <td colSpan="2"> Static Public Member Functions inherited from <a className="el" href="/content/api/cs/classkinetica_1_1KineticaData">kinetica.KineticaData</a></td>
      </tr>

      <tr className="memitem:a9474d49c9399dbe86f31a3ba07ff4691 inherit pub_static_methods_classkinetica_1_1KineticaData" id="r_a9474d49c9399dbe86f31a3ba07ff4691">
        <td className="memItemLeft" align="right" valign="top">static ? RecordSchema </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="/content/api/cs/classkinetica_1_1KineticaData#a9474d49c9399dbe86f31a3ba07ff4691">SchemaFromType</a> (System.Type t, <a className="el" href="/content/api/cs/classkinetica_1_1KineticaType">KineticaType</a>? ktype=null)</td>
      </tr>

      <tr className="memdesc:a9474d49c9399dbe86f31a3ba07ff4691 inherit pub_static_methods_classkinetica_1_1KineticaData">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Create an Avro Schema from a System.Type and a <a className="el" href="/content/api/cs/classkinetica_1_1KineticaType" title="Describes a Kinetica record type — its columns, properties, and Avro schema — and can create the type...">KineticaType</a>. <br /></td>
      </tr>

      <tr className="separator:a9474d49c9399dbe86f31a3ba07ff4691 inherit pub_static_methods_classkinetica_1_1KineticaData">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <div id="details" />

    <h2 className="groupheader">Detailed Description</h2>

    <div className="textblock">
      <p>A set of parameters for <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica/creatematerializedview#afbec7be04cf88d679d4d0092e264cf13">Kinetica.createMaterializedView</a>. </p>
      <p>Initiates the process of creating a materialized view, reserving the view's name to prevent other views or tables from being created with that name.</p>
      <p>For materialized view details and examples, see <a href="/content/concepts/materialized_views/" target="_top">Materialized Views</a>.</p>
      <p>The response contains <a className="el" href="/content/api/cs/classkinetica_1_1CreateMaterializedViewResponse#a1e24b1fd980fc69eb041fbbc0786c7b4">view\_id</a>, which is used to tag each subsequent operation (projection, union, aggregation, filter, or join) that will compose the view.</p>
      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateMaterializedView.cs#L24">24</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateMaterializedView.cs">CreateMaterializedView\.cs</a>.</p>
    </div>

    <h2 className="groupheader">Constructor & Destructor Documentation</h2>

    <div id="ab6c74daf528e3ba9b7ccb7a34d805a3f" />

    <h2 className="memtitle"><span className="permalink"><a href="#ab6c74daf528e3ba9b7ccb7a34d805a3f">◆ </a></span>CreateMaterializedViewRequest() <span className="overload">\[1/2]</span></h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">kinetica.CreateMaterializedViewRequest.CreateMaterializedViewRequest </td>
                  <td>(</td>

                  <td className="paramname">
                    <span className="paramname">
                      <span className="em" />
                    </span>
                  </td>

                  <td>)</td>

                  <td />
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel inline">inline</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Constructs a <a className="el" href="/content/api/cs/classkinetica_1_1CreateMaterializedViewRequest" title="A set of parameters for Kinetica.createMaterializedView.">CreateMaterializedViewRequest</a> object with default parameters. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateMaterializedView.cs#L499">499</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateMaterializedView.cs">CreateMaterializedView\.cs</a>.</p>
      </div>
    </div>

    <div id="a75838dba69a53e66516ea64aeb130a47" />

    <h2 className="memtitle"><span className="permalink"><a href="#a75838dba69a53e66516ea64aeb130a47">◆ </a></span>CreateMaterializedViewRequest() <span className="overload">\[2/2]</span></h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">kinetica.CreateMaterializedViewRequest.CreateMaterializedViewRequest </td>
                  <td>(</td>
                  <td className="paramtype">string</td>
                  <td className="paramname"><span className="paramname"><span className="em">table\_name</span></span>, </td>
                </tr>

                <tr>
                  <td className="paramkey" />

                  <td />

                  <td className="paramtype">IDictionary\< string, string ></td>
                  <td className="paramname"><span className="paramname"><span className="em">options</span></span><span className="paramdefsep"> = </span><span className="paramdefval">null</span> )</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel inline">inline</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Constructs a <a className="el" href="/content/api/cs/classkinetica_1_1CreateMaterializedViewRequest" title="A set of parameters for Kinetica.createMaterializedView.">CreateMaterializedViewRequest</a> object with the specified parameters. </p>

        <div className="dl params">
          <div className="dt">Parameters</div>

          <div className="dd">
            <table className="params">
              <tr>
                <td className="paramname">table\_name</td>
                <td>Name of the table to be created that is the top-level table of the materialized view, in \[schema\_name.]table\_name format, using standard <a href="/content/concepts/tables/#table-name-resolution" target="_top">name resolution rules</a> and meeting <a href="/content/concepts/tables/#table-naming-criteria" target="_top">table naming criteria</a>.</td>
              </tr>

              <tr>
                <td className="paramname">options</td>

                <td>
                  Optional parameters.

                  <ul>
                    <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ac732391c9d62c7aa9c1fcff562a34bf4">COLLECTION\_NAME</a>: \[DEPRECATED–please specify the containing schema for the materialized view as part of <span className="em">table\_name</span> and use <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica/createschema#ac754b44062e7b90b8afa50ddfa8ccbf2">Kinetica.createSchema</a> to create the schema if non-existent] Name of a schema which is to contain the newly created view. If the schema provided is non-existent, it will be automatically created. </li>
                    <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#abf86ab4c493a4711570a58526fca35e2">EXECUTE\_AS</a>: User name to use to run the refresh job. </li>

                    <li>
                      <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a407b631e63c726e069c96f9b0d2ecdb1">BUILD\_MATERIALIZED\_VIEW\_POLICY</a>: Sets startup materialized view rebuild scheme. Supported values:

                      <ul>
                        <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a384d5fd2aa87a11236d966f0d2b6e467">ALWAYS</a>: Rebuild as many materialized views as possible before accepting requests. </li>
                        <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a90480d030708f9196ed60baeb68a23e3">LAZY</a>: Rebuild the necessary materialized views at start, and load the remainder lazily. </li>
                        <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#aeed7b855b14ce5d9582fcc50bc925017">ON\_DEMAND</a>: Rebuild materialized views as requests use them. </li>
                        <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ad509d4a69fddbcb76309a3ffbca9eb74">SYSTEM</a>: Rebuild materialized views using the system-configured default. </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ad509d4a69fddbcb76309a3ffbca9eb74">SYSTEM</a>.
                    </li>

                    <li>
                      <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a6113b36b1f2f4aa977587b0620c4fc16">PERSIST</a>: If <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ae374f94d267bbe14b6cd10950c127ea5">TRUE</a>, then the materialized view specified in <span className="em">table\_name</span> will be persisted and will not expire unless a <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a2cd62ae289de1a6c4feb86c9341e83d3">TTL</a> is specified. If <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#abfe9748b78050f8cefa3165ae8a92a19">FALSE</a>, then the materialized view will be an in-memory table and will expire unless a <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a2cd62ae289de1a6c4feb86c9341e83d3">TTL</a> is specified otherwise. Supported values:

                      <ul>
                        <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ae374f94d267bbe14b6cd10950c127ea5">TRUE</a> </li>
                        <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#abfe9748b78050f8cefa3165ae8a92a19">FALSE</a> </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#abfe9748b78050f8cefa3165ae8a92a19">FALSE</a>.
                    </li>

                    <li>
                      <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#aa8589fd096de5e95e1647a1d1db49af4">ENABLE\_MV\_INPUT\_WRAPPERS</a>: If <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ae374f94d267bbe14b6cd10950c127ea5">TRUE</a>, each base table the view reads is accessed through a wrapper view so an in-progress out-of-place update cannot make a record momentarily disappear from the view, and a long refresh does not block updates to the base tables. Overrides the {"{"}gaia.enable\_mv\_input\_wrappers{"}"} configuration default when set. Supported values:

                      <ul>
                        <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ae374f94d267bbe14b6cd10950c127ea5">TRUE</a> </li>
                        <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#abfe9748b78050f8cefa3165ae8a92a19">FALSE</a> </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#abfe9748b78050f8cefa3165ae8a92a19">FALSE</a>.
                    </li>

                    <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ad3e0f5b4e21fa56666de23a423b7d7c0">REFRESH\_SPAN</a>: Sets the future time-offset(in seconds) at which periodic refresh stops. </li>
                    <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a1b37c768d510f7bdfe4043074ece4b74">REFRESH\_STOP\_TIME</a>: When <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a91009f31529d19cb8a53af8015824787">REFRESH\_METHOD</a> is <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a2b47c9ab4bc4e4b8258e93e08ca844ec">PERIODIC</a>, specifies the time at which a periodic refresh is stopped. Value is a datetime string with format 'YYYY-MM-DD HH:MM:SS'. </li>

                    <li>
                      <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a91009f31529d19cb8a53af8015824787">REFRESH\_METHOD</a>: Method by which the join can be refreshed when the data in underlying member tables have changed. Supported values:

                      <ul>
                        <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ac701da06265cdf25031899cbd6ca7923">MANUAL</a>: Refresh only occurs when manually requested by calling <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica/altertable#a6f0aeb998c8858266d7d265f9f42064a">Kinetica.alterTable</a> with an 'action' of 'refresh'. </li>
                        <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a0dc7df0f7746c37d967d0ff9600ae82c">ON\_QUERY</a>: Refresh any time the view is queried. </li>
                        <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a8c861e9a7ac5080212475f93f1b26249">ON\_CHANGE</a>: If possible, incrementally refresh (refresh just those records added) whenever an insert, update, delete or refresh of input table is done. A full refresh is done if an incremental refresh is not possible. </li>
                        <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a2b47c9ab4bc4e4b8258e93e08ca844ec">PERIODIC</a>: Refresh table periodically at rate specified by <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a48a4ed0783c53b48d483d6d6f320adaa">REFRESH\_PERIOD</a>. </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ac701da06265cdf25031899cbd6ca7923">MANUAL</a>.
                    </li>

                    <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a48a4ed0783c53b48d483d6d6f320adaa">REFRESH\_PERIOD</a>: When <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a91009f31529d19cb8a53af8015824787">REFRESH\_METHOD</a> is <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a2b47c9ab4bc4e4b8258e93e08ca844ec">PERIODIC</a>, specifies the period in seconds at which refresh occurs. </li>
                    <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ace5e5d7f2f18d7f40edf7115dff37ffb">REFRESH\_START\_TIME</a>: When <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a91009f31529d19cb8a53af8015824787">REFRESH\_METHOD</a> is <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a2b47c9ab4bc4e4b8258e93e08ca844ec">PERIODIC</a>, specifies the first time at which a refresh is to be done. Value is a datetime string with format 'YYYY-MM-DD HH:MM:SS'. </li>
                    <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a2cd62ae289de1a6c4feb86c9341e83d3">TTL</a>: Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the table specified in <span className="em">table\_name</span> . </li>
                  </ul>

                  The default value is an empty Dictionary.
                </td>
              </tr>
            </table>
          </div>
        </div>

        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateMaterializedView.cs#L733">733</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateMaterializedView.cs">CreateMaterializedView\.cs</a>.</p>
      </div>
    </div>

    <h2 className="groupheader">Property Documentation</h2>

    <div id="a260d6cd873e362adc49cf04a45d8351d" />

    <h2 className="memtitle"><span className="permalink"><a href="#a260d6cd873e362adc49cf04a45d8351d">◆ </a></span>options</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">IDictionary\<string, string> kinetica.CreateMaterializedViewRequest.options = new Dictionary\<string, string>()</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel get">get</span><span className="mlabel set">set</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Optional parameters. </p>

        <ul>
          <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ac732391c9d62c7aa9c1fcff562a34bf4">COLLECTION\_NAME</a>: \[DEPRECATED–please specify the containing schema for the materialized view as part of <a className="el" href="#ae4efb251be00e32b046b0111d659db9f" title="Name of the table to be created that is the top-level table of the materialized view,...">CreateMaterializedViewRequest.table\_name</a> and use <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica/createschema#ac754b44062e7b90b8afa50ddfa8ccbf2">Kinetica.createSchema</a> to create the schema if non-existent] Name of a schema which is to contain the newly created view. If the schema provided is non-existent, it will be automatically created. </li>
          <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#abf86ab4c493a4711570a58526fca35e2">EXECUTE\_AS</a>: User name to use to run the refresh job. </li>

          <li>
            <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a407b631e63c726e069c96f9b0d2ecdb1">BUILD\_MATERIALIZED\_VIEW\_POLICY</a>: Sets startup materialized view rebuild scheme. Supported values:

            <ul>
              <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a384d5fd2aa87a11236d966f0d2b6e467">ALWAYS</a>: Rebuild as many materialized views as possible before accepting requests. </li>
              <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a90480d030708f9196ed60baeb68a23e3">LAZY</a>: Rebuild the necessary materialized views at start, and load the remainder lazily. </li>
              <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#aeed7b855b14ce5d9582fcc50bc925017">ON\_DEMAND</a>: Rebuild materialized views as requests use them. </li>
              <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ad509d4a69fddbcb76309a3ffbca9eb74">SYSTEM</a>: Rebuild materialized views using the system-configured default. </li>
            </ul>

            The default value is <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ad509d4a69fddbcb76309a3ffbca9eb74">SYSTEM</a>.
          </li>

          <li>
            <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a6113b36b1f2f4aa977587b0620c4fc16">PERSIST</a>: If <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ae374f94d267bbe14b6cd10950c127ea5">TRUE</a>, then the materialized view specified in <a className="el" href="#ae4efb251be00e32b046b0111d659db9f" title="Name of the table to be created that is the top-level table of the materialized view,...">CreateMaterializedViewRequest.table\_name</a> will be persisted and will not expire unless a <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a2cd62ae289de1a6c4feb86c9341e83d3">TTL</a> is specified. If <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#abfe9748b78050f8cefa3165ae8a92a19">FALSE</a>, then the materialized view will be an in-memory table and will expire unless a <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a2cd62ae289de1a6c4feb86c9341e83d3">TTL</a> is specified otherwise. Supported values:

            <ul>
              <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ae374f94d267bbe14b6cd10950c127ea5">TRUE</a> </li>
              <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#abfe9748b78050f8cefa3165ae8a92a19">FALSE</a> </li>
            </ul>

            The default value is <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#abfe9748b78050f8cefa3165ae8a92a19">FALSE</a>.
          </li>

          <li>
            <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#aa8589fd096de5e95e1647a1d1db49af4">ENABLE\_MV\_INPUT\_WRAPPERS</a>: If <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ae374f94d267bbe14b6cd10950c127ea5">TRUE</a>, each base table the view reads is accessed through a wrapper view so an in-progress out-of-place update cannot make a record momentarily disappear from the view, and a long refresh does not block updates to the base tables. Overrides the {"{"}gaia.enable\_mv\_input\_wrappers{"}"} configuration default when set. Supported values:

            <ul>
              <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ae374f94d267bbe14b6cd10950c127ea5">TRUE</a> </li>
              <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#abfe9748b78050f8cefa3165ae8a92a19">FALSE</a> </li>
            </ul>

            The default value is <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#abfe9748b78050f8cefa3165ae8a92a19">FALSE</a>.
          </li>

          <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ad3e0f5b4e21fa56666de23a423b7d7c0">REFRESH\_SPAN</a>: Sets the future time-offset(in seconds) at which periodic refresh stops. </li>
          <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a1b37c768d510f7bdfe4043074ece4b74">REFRESH\_STOP\_TIME</a>: When <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a91009f31529d19cb8a53af8015824787">REFRESH\_METHOD</a> is <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a2b47c9ab4bc4e4b8258e93e08ca844ec">PERIODIC</a>, specifies the time at which a periodic refresh is stopped. Value is a datetime string with format 'YYYY-MM-DD HH:MM:SS'. </li>

          <li>
            <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a91009f31529d19cb8a53af8015824787">REFRESH\_METHOD</a>: Method by which the join can be refreshed when the data in underlying member tables have changed. Supported values:

            <ul>
              <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ac701da06265cdf25031899cbd6ca7923">MANUAL</a>: Refresh only occurs when manually requested by calling <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica/altertable#a6f0aeb998c8858266d7d265f9f42064a">Kinetica.alterTable</a> with an 'action' of 'refresh'. </li>
              <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a0dc7df0f7746c37d967d0ff9600ae82c">ON\_QUERY</a>: Refresh any time the view is queried. </li>
              <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a8c861e9a7ac5080212475f93f1b26249">ON\_CHANGE</a>: If possible, incrementally refresh (refresh just those records added) whenever an insert, update, delete or refresh of input table is done. A full refresh is done if an incremental refresh is not possible. </li>
              <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a2b47c9ab4bc4e4b8258e93e08ca844ec">PERIODIC</a>: Refresh table periodically at rate specified by <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a48a4ed0783c53b48d483d6d6f320adaa">REFRESH\_PERIOD</a>. </li>
            </ul>

            The default value is <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ac701da06265cdf25031899cbd6ca7923">MANUAL</a>.
          </li>

          <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a48a4ed0783c53b48d483d6d6f320adaa">REFRESH\_PERIOD</a>: When <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a91009f31529d19cb8a53af8015824787">REFRESH\_METHOD</a> is <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a2b47c9ab4bc4e4b8258e93e08ca844ec">PERIODIC</a>, specifies the period in seconds at which refresh occurs. </li>
          <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#ace5e5d7f2f18d7f40edf7115dff37ffb">REFRESH\_START\_TIME</a>: When <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a91009f31529d19cb8a53af8015824787">REFRESH\_METHOD</a> is <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a2b47c9ab4bc4e4b8258e93e08ca844ec">PERIODIC</a>, specifies the first time at which a refresh is to be done. Value is a datetime string with format 'YYYY-MM-DD HH:MM:SS'. </li>
          <li> <a className="el" href="/content/api/cs/structkinetica_1_1CreateMaterializedViewRequest_1_1Options#a2cd62ae289de1a6c4feb86c9341e83d3">TTL</a>: Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the table specified in <a className="el" href="#ae4efb251be00e32b046b0111d659db9f" title="Name of the table to be created that is the top-level table of the materialized view,...">CreateMaterializedViewRequest.table\_name</a>. </li>
        </ul>

        <p>The default value is an empty Dictionary.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateMaterializedView.cs#L495">495</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateMaterializedView.cs">CreateMaterializedView\.cs</a>.</p>
      </div>
    </div>

    <div id="ae4efb251be00e32b046b0111d659db9f" />

    <h2 className="memtitle"><span className="permalink"><a href="#ae4efb251be00e32b046b0111d659db9f">◆ </a></span>table\_name</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">string kinetica.CreateMaterializedViewRequest.table\_name</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel get">get</span><span className="mlabel set">set</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Name of the table to be created that is the top-level table of the materialized view, in \[schema\_name. </p>
        <p>]table\_name format, using standard <a href="/content/concepts/tables/#table-name-resolution" target="_top">name resolution rules</a> and meeting <a href="/content/concepts/tables/#table-naming-criteria" target="_top">table naming criteria</a>. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateMaterializedView.cs#L270">270</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateMaterializedView.cs">CreateMaterializedView\.cs</a>.</p>
      </div>
    </div>

    <hr />

    The documentation for this class was generated from the following file:

    <ul>
      <li>Kinetica/Protocol/<a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateMaterializedView.cs">CreateMaterializedView\.cs</a></li>
    </ul>
  </div>
</div>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.