Bring data from Carta to your Lakehouse.
Tip: The stream can be found more easily by typing its name.Select the streams and click Next.
Firms
id
: Unique identifier for the firm.name
: Name of the firm.Funds
id
: Unique identifier for the fund.firmId
: Identifier for the firm associated with the fund.name
: Name of the fund.Investments
id
: Unique identifier for the investment.firmId
: Identifier for the firm associated with the investment.fundId
: Identifier for the fund associated with the investment.companyId
: Identifier for the company associated with the investment.legalName
: Legal name of the company.doingBusinessAsName
: Doing business as name of the company.website
: Website of the company.country
: Country of the company.stateOfIncorporation
: State of incorporation of the company.cartaCompany
: Whether the company is a Carta company.reference_cap_table_id
: Reference capitalization table ID.Capitalization Tables
id
: Unique identifier for the capitalization table.firmId
: Identifier for the firm associated with the capitalization table.fundId
: Identifier for the fund associated with the capitalization table.companyId
: Identifier for the company associated with the capitalization table.name
: Name of the capitalization table.type
: Type of the capitalization table.asOfDate.value
: The date as of which the capitalization table is valid.Capitalization Table Details
id
: Unique identifier for the capitalization table detail.firmId
: Identifier for the firm associated with the capitalization table.fundId
: Identifier for the fund associated with the capitalization table.companyId
: Identifier for the company associated with the capitalization table.capitalizationTableId
: Identifier for the capitalization table.asOfDate.value
: The date as of which the capitalization table details are valid.summary
: An object containing summary information for the capitalization table (e.g., fullyDilutedShares
, outstandingShares
, cashRaised
).shareClassDetails
: A list of objects with details for each share class.optionPoolSummaries
: A list of objects with summaries for each option pool.warrantBlockDetails
: A list of objects with details for each warrant block.Fund Investment Documents
documentId
: Unique identifier for the document.fundId
: Identifier for the fund associated with the document.firmId
: Identifier for the firm associated with the document.documentName
: Name of the document.fundName
: Name of the fund.firmName
: Name of the firm.effectiveDate.value
: Effective date of the document.sharedDate.value
: Date when the document was shared.portfolioId
: Identifier for the portfolio this document belongs to.Fund Investment Document Download
portfolioId
: Identifier for the portfolio.documentId
: Unique identifier for the document.documentName
: Name of the document.downloadUrl
: URL to download the document.downloadUrlExpirationTime
: Expiration time for the download URL.Issuers
id
: Unique identifier for the issuer.legalName
: Legal name of the issuer.doingBusinessAsName
: Doing business as name of the issuer.website
: Website URL of the issuer.status
: Status of the issuer.createdAt
: Timestamp when the issuer was created.updatedAt
: Timestamp when the issuer was last updated.Issuer Capitalization Table
issuerId
: Unique identifier for the issuer.asOfDate.value
: The date as of which the capitalization table is valid.summary
: An object containing summary information for the capitalization table.shareClassDetails
: A list of objects with details for each share class.shareClassSummaries
: A list of objects with summaries for each share class.optionPoolSummaries
: A list of objects with summaries for each option pool.warrantBlockDetails
: A list of objects with details for each warrant block.warrantBlockSummaries
: A list of objects with summaries for each warrant block.noteBlockSummaries
: A list of objects with summaries for each note block.Issuer Stakeholder Capitalization Table
issuerId
: Unique identifier for the issuer.asOfDate
: Date as of which the capitalization table is valid.stakeholderGroups
: A list of objects, each representing a stakeholder group with detailed information.Investor Stakeholder Capitalization Table
id
: Unique identifier for the stakeholder capitalization table.companyId
: Identifier for the company.asOfDate
: Date as of which the capitalization table is valid.firmId
: Identifier for the firm.fundId
: Identifier for the fund.capitalizationTableId
: Identifier for the capitalization table.stakeholderGroups
: A list of objects, each representing a stakeholder group with detailed information.Portfolios
portfolioId
: Unique identifier for the portfolio.legalName
: Legal name of the portfolio.createTime
: Timestamp when the portfolio was created.Portfolio Issuers
id
: Unique identifier for the issuer.portfolioId
: Identifier for the portfolio associated with the issuer.legalName
: Legal name of the issuer.doingBusinessAsName
: Doing business as name of the issuer.website
: Website URL of the issuer.