Skip to content

The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.

1006 B
Raw Blame
import type { DestinationPanelSchemaType } from '../DestinationPanel/DestinationForm/DestinationForm.schema'

export const describeBigQueryTableLayout = (
  option: NonNullable<DestinationPanelSchemaType['tableOptions']>[number]
) => {
  const partition = option.partitionBy
  let partitionDescription = 'No partitioning'
  if (partition?.kind === 'time_column') {
    partitionDescription = `Partition by ${partition.column || 'Not selected'} (${partition.granularity ?? 'day'})`
  }
  if (partition?.kind === 'ingestion_time') {
    partitionDescription = `Partition by ingestion time (${partition.granularity ?? 'day'})`
  }
  if (partition?.kind === 'integer_range') {
    partitionDescription = `Partition by ${partition.column || 'Not selected'} (range ${partition.start} to ${partition.end}, interval ${partition.interval})`
  }
  const clustering = option.clusterBy?.length
    ? `Cluster by ${option.clusterBy.join(', ')}`
    : 'No clustering'
  return `${partitionDescription}; ${clustering}`
}