page-index.js

module.exports = [
  {
    title: "Use Timescale",
    href: "use-timescale",
    filePath: "index.md",
    pageComponents: ["content-list"],
    excerpt:
      "How to connect to Timescale, administer, and configure the database.",
    children: [
      {
        title: "Timescale Cloud regions",
        href: "regions",
        excerpt: "Timescale AWS regions",
      },
      {
        title: "Timescale Cloud services",
        href: "services",
        excerpt: "About Timescale Cloud services",
        children: [
          {
            title: "Services overview",
            href: "service-overview",
            excerpt: "Timescale services overview",
          },
          {
            title: "Service explorer",
            href: "service-explorer",
            excerpt: "Timescale services explorer",
          },
          {
            title: "Service management",
            href: "service-management",
            excerpt:
              "Timescale services operations, Service management tab",
          },
          {
            title: "Manually change resources",
            href: "change-resources",
            excerpt: "Manually adjust your service resources",
          },
          {
            title: "Connection pooling",
            href: "connection-pooling",
            excerpt:
              "Using a connection pool with your Timescale services",
          },
          {
            title: "I/O boost",
            href: "i-o-boost",
          },
          {
            title: "Troubleshooting Timescale services",
            href: "troubleshooting",
            type: "placeholder",
          },
        ],
      },
      {
        title: "Control user access to Timescale Cloud projects",
        href: "members",
        excerpt: "User management in Timescale Cloud",
      },
      {
        title: "Write data",
        href: "write-data",
        children: [
          {
            title: "About writing data",
            href: "about-writing-data",
            excerpt: "Write data into hypertables",
          },
          {
            title: "Insert data",
            href: "insert",
            excerpt: "Insert data into hypertables",
          },
          {
            title: "Update data",
            href: "update",
            excerpt: "Update data in hypertables",
          },
          {
            title: "Upsert data",
            href: "upsert",
            excerpt: "Upsert data into hypertables",
          },
          {
            title: "Delete data",
            href: "delete",
            excerpt: "Delete data from hypertables",
          },
        ],
      },
      {
        title: "Query data",
        href: "query-data",
        children: [
          {
            title: "About querying data",
            href: "about-query-data",
            excerpt: "Learn how to query data in Timescale",
          },
          {
            title: "SELECT data",
            href: "select",
            excerpt: "Select data in hypertables",
          },
          {
            title: "Perform DISTINCT queries with SkipScan",
            href: "skipscan",
            excerpt: "Make DISTINCT queries faster with SkipScan",
          },
          {
            title: "Perform advanced analytic queries",
            href: "advanced-analytic-queries",
            excerpt: "Use advanced analytics queries",
          },
          {
            title: "Troubleshooting",
            href: "troubleshooting",
            type: "placeholder",
          },
        ],
      },
      {
        title: "Time buckets",
        href: "time-buckets",
        excerpt: "Aggregate data by time interval with time buckets",
        children: [
          {
            title: "About time buckets",
            href: "about-time-buckets",
            excerpt: "Learn how time buckets work in Timescale.",
          },
          {
            title: "Use time buckets to group time-series data",
            href: "use-time-buckets",
            excerpt:
              "How to group time series data with the time_bucket function.",
          },
          {
            title: "Troubleshoot problems with time buckets",
            href: "troubleshooting",
            type: "placeholder",
          },
        ],
      },
      {
        title: "Hypertables",
        href: "hypertables",
        children: [
          {
            title: "About hypertables",
            href: "about-hypertables",
            excerpt: "Learn about hypertables in Timescale",
          },
          {
            title: "Create hypertables",
            href: "create",
            excerpt: "Create hypertables",
          },
          {
            title: "Change hypertable chunk intervals",
            href: "change-chunk-intervals",
            excerpt: "Change and view chunk time intervals for a hypertable",
          },
          {
            title: "Alter hypertables",
            href: "alter",
            excerpt: "Alter hypertables",
          },
          {
            title: "Create unique indexes on hypertables",
            href: "hypertables-and-unique-indexes",
            excerpt: "Create hypertables with unique indexes",
          },
          {
            title: "Improve query performance",
            href: "improve-query-performance",
            excerpt: "Skip chunks",
          },
          {
            title: "Drop hypertables",
            href: "drop",
            excerpt: "Drop hypertables",
          },
          {
            title: "Troubleshoot hypertables",
            href: "troubleshooting",
            type: "placeholder",
            excerpt: "Troubleshooting and error fixes for hypertables",
          },
        ],
      },
      {
        title: "Hypercore",
        href: "hypercore",
        excerpt:
          "Seamlessly switch between row-oriented and column-oriented storage",
        children: [
          {
            title: "Optimize your data for real-time analytics",
            href: "real-time-analytics-in-hypercore",
            excerpt: "Automate",
          },
          {
            title: "Modify data in Hypercore",
            href: "modify-data-in-hypercore",
            excerpt: "Update data stored in the columnstore",
          },
          {
            title: "Improve query and upsert performance",
            href: "secondary-indexes",
            excerpt: "Automate",
          },
        ],
      },
      {
        title: "Schema management",
        href: "schema-management",
        children: [
          {
            title: "About schemas",
            href: "about-schemas",
            excerpt: "About hypertable schemas",
          },
          {
            title: "About indexing",
            href: "about-indexing",
            excerpt: "About schema indexes",
          },
          {
            title: "About tablespaces",
            href: "about-tablespaces",
            excerpt: "About schema tablespaces",
          },
          {
            title: "About constraints",
            href: "about-constraints",
            excerpt: "About schema constraints",
          },
          {
            title: "Alter hypertables",
            href: "alter",
            excerpt: "Change the schema of a hypertable",
          },
          {
            title: "Index",
            href: "indexing",
            excerpt: "Create an index on a hypertable",
          },
          {
            title: "Triggers",
            href: "triggers",
            excerpt: "Create triggers on a hypertable",
          },
          {
            title: "JSON",
            href: "json",
            excerpt: "Using JSON data types in a hypertable",
          },
          {
            title: "Foreign data wrappers",
            href: "foreign-data-wrappers",
          },
          {
            title: "Troubleshoot schema management",
            href: "troubleshooting",
            type: "placeholder",
          },
        ],
      },
      {
        title: "Configuration",
        href: "configuration",
        excerpt: "Configure your Timescale Cloud service",
        children: [
          {
            title: "About Configuration",
            href: "about-configuration",
            excerpt:
              "Overview of configuration options and methods for PostgreSQL and Timescale",
          },
          {
            title: "Customize configuration",
            href: "customize-configuration",
            excerpt: "Customize your Timescale database configuration",
          },
          {
            title: "Advanced parameters",
            href: "advanced-parameters",
            excerpt:
              "Configure advanced database parameters for your Timescale service",
          },
          {
            title: "Troubleshooting",
            href: "troubleshooting",
            type: "placeholder",
          },
        ],
      },
      {
        title: "Import and ingest data",
        href: "ingest-data",
        excerpt: "Ingest data into a Timescale Cloud service from third-party sources",
        children: [
          {
            title: "Import data from CSV",
            href: "import-csv",
            excerpt:
              "Import data into a Timescale Cloud service from an external .csv file",
          },
          {
            title: "Import data from MySQL",
            href: "import-mysql",
            excerpt:
              "Import data into a Timescale Cloud service from a MySQL instance",
          },
          {
            title: "Import data from Parquet",
            href: "import-parquet",
            excerpt:
              "Import data into a Timescale Cloud service from a Parquet file",
          },
          {
            title: "Ingest data with Kafka",
            href: "ingest-kafka",
            excerpt: "Import data into a Timescale Cloud service using the PostgreSQL Kafka connector",
          },
          {
            title: "Ingest metrics with Telegraf",
            href: "ingest-telegraf",
            excerpt: "Ingest metrics into a Timescale Cloud service using the Telegraf plugin",
          },
        ],
      },
      {
        title: "Continuous aggregates",
        href: "continuous-aggregates",
        children: [
          {
            title: "About continuous aggregates",
            href: "about-continuous-aggregates",
            excerpt: "About continuous aggregates",
          },
          {
            title: "Create a continuous aggregate",
            href: "create-a-continuous-aggregate",
            excerpt: "Create continuous aggregates",
          },
          {
            title: "Hierarchical continuous aggregates",
            href: "hierarchical-continuous-aggregates",
          },
          {
            title: "Refresh policies for continuous aggregates",
            href: "refresh-policies",
            excerpt: "Manage refresh policies for continuous aggregates",
          },
          {
            title: "Create an index on a continuous aggregate",
            href: "create-index",
            excerpt:
              "Manage automatic index creation and manually create additional indexes",
          },
          {
            title: "Time in continuous aggregates",
            href: "time",
            excerpt: "Manage time in continuous aggregates",
          },
          {
            title: "Drop data from continuous aggregates",
            href: "drop-data",
            excerpt: "Drop data from continuous aggregates",
          },
          {
            title: "Manage materialized hypertables",
            href: "materialized-hypertables",
            excerpt: "Manage materialized hypertables in continuous aggregates",
          },
          {
            title: "Real time aggregates",
            href: "real-time-aggregates",
            excerpt: "Manage real time aggregates in continuous aggregates",
          },
          {
            title: "Compress continuous aggregates",
            href: "compression-on-continuous-aggregates",
            excerpt: "Compress continuous aggregates",
          },
          {
            title: "Migrate a continuous aggregate to the new form",
            href: "migrate",
            excerpt:
              "Migrate old continuous aggregates to the new form introduced in Timescale 2.7",
          },
          {
            title: "Troubleshoot continuous aggregates",
            href: "troubleshooting",
            type: "placeholder",
            excerpt: "Troubleshoot continuous aggregates",
          },
        ],
      },
      {
        title: "Alerting",
        href: "alerting",
        excerpt: "Configure alerting within Timescale",
      },
      {
        title: "Data retention",
        href: "data-retention",
        excerpt: "Drop data by time value either automatically or manually",
        children: [
          {
            title: "About data retention",
            href: "about-data-retention",
            excerpt: "Learn about data retention in Timescale",
          },
          {
            title: "About data retention with continuous aggregates",
            href: "data-retention-with-continuous-aggregates",
            excerpt: "Using data retention policies with continuous aggregates",
          },
          {
            title: "Create a retention policy",
            href: "create-a-retention-policy",
            excerpt: "Create a data retention policy",
          },
          {
            title: "Manually drop chunks",
            href: "manually-drop-chunks",
            excerpt: "Manually drop chunks",
          },
          {
            title: "Troubleshooting data retention",
            href: "troubleshooting",
            type: "placeholder",
            excerpt: "Troubleshoot data retention",
          },
        ],
      },
      {
        title: "Tiered storage",
        href: "data-tiering",
        excerpt: "Save on storage costs by tiering older data to a low-cost bottomless object storage tier",
        children: [
          {
            title: "About the object storage tier",
            href: "about-data-tiering",
            excerpt:
              "Learn how the object storage tier helps you save on storage costs",
          },
          {
            title: "Manage tiering",
            href: "enabling-data-tiering",
            excerpt:
              "How to enable the object storage tier",
          },
          {
            title: "Querying tiered data",
            href: "querying-tiered-data",
            excerpt:
              "How to query tiered data",
          },
          {
            title: "Replicas and forks with tiered data",
            href: "tiered-data-replicas-forks",
            excerpt:
              "How tiered data works on replicas and forks",
          },
          {
            title: "Troubleshooting",
            href: "troubleshooting",
            type: "placeholder",
          },
        ],
      },
      {
        title: "Hyperfunctions",
        href: "hyperfunctions",
        pageComponents: ["featured-cards"],
        featuredChildren: [
          "/use-timescale/:currentVersion:/hyperfunctions/function-pipelines",
          "/use-timescale/:currentVersion:/hyperfunctions/approx-count-distincts",
          "/use-timescale/:currentVersion:/hyperfunctions/stats-aggs",
          "/use-timescale/:currentVersion:/hyperfunctions/gapfilling-interpolation",
          "/use-timescale/:currentVersion:/hyperfunctions/percentile-approx",
          "/use-timescale/:currentVersion:/hyperfunctions/counter-aggregation",
          "/use-timescale/:currentVersion:/hyperfunctions/time-weighted-averages",
        ],
        children: [
          {
            title: "About hyperfunctions",
            href: "about-hyperfunctions",
            excerpt:
              "Learn about Timescale hyperfunctions for additional analysis",
          },
          {
            title: "Function pipelines",
            href: "function-pipelines",
            excerpt:
              "Use functional programming to simplify complex SQL queries",
          },
          {
            title: "Approximate count distincts",
            href: "approx-count-distincts",
            type: "directory",
            excerpt: "Count the number of unique values in a dataset",
            children: [
              {
                title: "Hyperloglog",
                href: "hyperloglog",
                tags: ["hyperfunctions", "toolkit", "query", "timescaledb"],
                excerpt: "Learn about the hyperloglog hyperfunction",
              },
            ],
          },
          {
            title: "Statistical aggregates",
            href: "stats-aggs",
            excerpt:
              "Calculate descriptive statistics and models, including averages, standard deviation, linear regression, and more",
          },
          {
            title: "Gapfilling and interpolation",
            href: "gapfilling-interpolation",
            type: "directory",
            excerpt: "Fill in data collected at irregular time intervals",
            children: [
              {
                title: "Time bucket gapfill",
                href: "time-bucket-gapfill",
                excerpt:
                  "Learn about the time bucket gapfillling hyperfunction",
              },
              {
                title: "Last observation carried forward",
                href: "locf",
                excerpt: "Learn about the locf hyperfunction",
              },
            ],
          },
          {
            title: "Percentile approximation",
            href: "percentile-approx",
            type: "directory",
            excerpt: "Calculate percentiles",
            children: [
              {
                title: "Approximate percentile",
                href: "approximate-percentile",
                excerpt: "Learn about the approximate percentile hyperfunction",
              },
              {
                title: "Advanced aggregation methods",
                href: "advanced-agg",
                excerpt:
                  "Learn about advanced aggregation methods for hyperfunctions",
              },
            ],
          },
          {
            title: "Counter aggregation",
            href: "counter-aggregation",
            type: "directory",
            excerpt: "Calculate statistics from gauges and counters",
            children: [
              {
                title: "Counter aggregates",
                href: "counter-aggs",
                excerpt: "Learn about the counter aggregate hyperfunction",
              },
            ],
          },
          {
            title: "Time-weighted averages",
            href: "time-weighted-averages",
            type: "directory",
            excerpt: "Calculate time-weighted averages",
            children: [
              {
                title: "Time-weighted averages",
                href: "time-weighted-average",
                excerpt: "Learn about the time-weighted averages hyperfunction",
              },
            ],
          },
          {
            title: "Heartbeat aggregation",
            href: "heartbeat-agg",
            excerpt:
              "Build a model of system health from a series of health check timestamps",
          },
          {
            title: "Troubleshoot hyperfunctions",
            href: "troubleshooting",
            type: "placeholder",
          },
        ],
      },
      {
        title: "Metrics and logging",
        href: "metrics-logging",
        excerpt: "Timescale metrics and logging",
        children: [
          {
            title: "Service metrics",
            href: "service-metrics",
            excerpt: "Timescale services metrics",
          },
          {
            title: "Service logs",
            href: "service-logs",
            excerpt: "Timescale services logs",
          },
          {
            title: "Insights",
            href: "insights",
            excerpt: "Query-level performance insights",
          },
          {
            title: "Third-party monitoring for Timescale Cloud Services",
            href: "integrations",
            excerpt:
              "Export telemetry data to a third-party monitoring service",
          },
          {
            title: "Export to Prometheus",
            href: "metrics-to-prometheus",
            excerpt:
              "Export telemetry data to Prometheus",
          },
        ],
      },
      {
        title: "High availability and read replication",
        href: "ha-replicas",
        excerpt: "Timescale high availability and read replication",
        children: [
          {
            title: "Manage high availability",
            href: "high-availability",
            excerpt: "Set up HA replicas on Timescale for high availability",
          },
          {
            title: "Manage read replication",
            href: "read-scaling",
            excerpt: "Understand how read scaling works in Timescale",
          },
        ],
      },
      {
        title: "Maintenance and upgrades",
        href: "upgrades",
        excerpt: "Keep your Timescale Cloud service up-to-date",
      },
      {
        title: "PostgreSQL extensions",
        href: "extensions",
        excerpt: "Timescale PostgreSQL extensions",
        children: [
          {
            title: "pgvector extension",
            href: "pgvector",
            excerpt: "Using the pgvector PostgreSQL extension",
          },
          {
            title: "pgcrypto extension",
            href: "pgcrypto",
            excerpt: "Using the pgcrypto PostgreSQL extension",
          },
          {
            title: "postgis extension",
            href: "postgis",
            excerpt: "Using the postgis PostgreSQL extension",
          },
        ]
      },
      {
        title: "Backup, restore, and PITR",
        href: "backup-restore",
        children: [
          {
            title: "Backup and restore",
            href: "backup-restore-cloud",
            excerpt: "Timescale backup and restore",
          },
          {
            title: "Point-in-time recovery",
            href: "point-in-time-recovery",
            excerpt: "PITR on Timescale services"
          }
        ]
      },
      {
        title: "Jobs",
        href: "jobs",
        children: [
          {
            title: "Create and manage jobs",
            href: "create-and-manage-jobs",
            excerpt: "Create, test, alter, and delete jobs",
          },
          {
            title: "Use a job for generic retention",
            href: "example-generic-retention",
            excerpt: "A job example for a retention policy",
          },
          {
            title: "Use a job for tablespace management",
            href: "example-tiered-storage",
            excerpt:
              "A job example for automatically moving chunks between tablespaces",
          },
          {
            title: "Use a job for downsampling and compression",
            href: "example-downsample-and-compress",
            excerpt: "A job example for downsampling and compressing data",
          },
          {
            title: "Troubleshooting",
            href: "troubleshooting",
            type: "placeholder",
          },
        ],
      },
      {
        title: "Integrations",
        href: "integrations",
        excerpt: "Integrate third-party solutions with Timescale Cloud",
        children: [
          {
            title: "Find your connection details",
            href: "find-connection-details",
            excerpt: "Find connection information for your Timescale Cloud service",
          },
          {
            title: "Amazon CloudWatch",
            href: "cloudwatch",
            excerpt: "Integrate Amazon Cloudwatch with Timescale Cloud",
          },
          {
            title: "Amazon SageMaker",
            href: "amazon-sagemaker",
            excerpt: "Integrate Amazon SageMaker with Timescale Cloud",
          },
          {
            title: "Amazon Web Services",
            href: "aws",
            excerpt: "Integrate AWS with Timescale Cloud",
          },
          {
            title: "Apache Airflow",
            href: "apache-airflow",
            excerpt: "Integrate Apache Airflow with Timescale products",
          },
          {
            title: "Apache Kafka",
            href: "apache-kafka",
            excerpt: "Integrate Apache Kafka with Timescale Cloud",
          },
          {
            title: "AWS Lambda",
            href: "aws-lambda",
            excerpt: "Integrate AWS Lambda with Timescale Cloud",
          },
          {
            title: "Azure Data Studio",
            href: "azure-data-studio",
            excerpt: "Integrate Azure Data Studio with Timescale Cloud",
          },
          {
            title: "Corporate data center",
            href: "corporate-data-center",
            excerpt: "Integrate your corporate data center with Timescale Cloud",
          },
          {
            title: "Datadog",
            href: "datadog",
            excerpt: "Integrate Datadog with Timescale Cloud",
          },
          {
            title: "DBeaver",
            href: "dbeaver",
            excerpt: "Integrate DBeaver with Timescale Cloud",
          },
          {
            title: "Decodable",
            href: "decodable",
            excerpt: "Integrate Decodable with Timescale Cloud",
          },
          {
            title: "Fivetran",
            href: "fivetran",
            excerpt: "Integrate Fivetran with Timescale Cloud",
          },
          {
            title: "Google Cloud",
            href: "google-cloud",
            excerpt: "Integrate Google Cloud with Timescale Cloud",
          },
          {
            title: "Grafana",
            href: "grafana",
            excerpt: "Integrate Grafana with Timescale products",
          },
          {
            title: "Microsoft Azure",
            href: "microsoft-azure",
            excerpt: "Integrate Microsoft Azure with Timescale Cloud",
          },
          {
            title: "pgAdmin",
            href: "pgadmin",
            excerpt: "Integrate pgAdmin with Timescale Cloud",
          },
          {
            title: "PostgreSQL",
            href: "postgresql",
            excerpt: "Integrate PostgreSQL with Timescale Cloud",
          },
          {
            title: "Prometheus",
            href: "prometheus",
            excerpt: "Integrate Prometheus with Timescale Cloud",
          },
          {
            title: "Power BI",
            href: "power-bi",
            excerpt: "Integrate Power BI with Timescale Cloud",
          },
          {
            title: "psql",
            href: "psql",
            excerpt: "Connect to Timescale products with psql",
          },
          {
            title: "qStudio",
            href: "qstudio",
            excerpt: "Integrate qstudio with Timescale Cloud",
          },
          {
            title: "Supabase",
            href: "supabase",
            excerpt: "Integrate Supabase with Timescale products",
          },
          {
            title: "Tableau",
            href: "tableau",
            excerpt: "Integrate Tableau with Timescale Cloud",
          },
          {
            title: "Terraform",
            href: "terraform",
            excerpt: "Integrate Terraform with Timescale Cloud",
          },
          {
            title: "Troubleshooting Timescale integrations",
            href: "troubleshooting",
            type: "placeholder",
            excerpt: "Resolve integration issues",
          },
        ],
      },
      {
        title: "Security",
        href: "security",
        excerpt: "Learn how your Timescale instance is secured",
        children: [
          {
            title: "Security overview",
            href: "overview",
            excerpt: "Get an overview of Timescale security",
          },
          {
            title: "SAML authentication",
            href: "saml",
            excerpt: "SAML / SSO authentication for your Timescale account",
          },
          {
            title: "Multi-factor authentication",
            href: "multi-factor-authentication",
            excerpt: "Multi-factor authentication for your Timescale account",
          },
          {
            title: "Client credentials",
            href: "client-credentials",
            excerpt: "Client credentials to programmatically access your Timescale account",
          },
          {
            title: "Read only role",
            href: "read-only-role",
            excerpt: "Create a read-only role to access your database",
          },
          {
            title: "Connect with a stricter SSL mode",
            href: "strict-ssl",
            excerpt:
              "Connect to Timescale with a stricter SSL mode of verify-ca or verify-full",
          },
          {
            title: "Connect securely from any cloud",
            href: "transit-gateway",
            excerpt: "Peer your Timescale Cloud service with AWS Transit Gateway",
          },
          {
            title: "VPC peering and AWS PrivateLink",
            href: "vpc",
            excerpt: "Secure your Timescale Service with VPC peering and AWS PrivateLink",
          },
          {
            title: "IP allow list",
            href: "ip-allow-list",
            excerpt:
              "Create a list of IP addresses that can access your services",
          },
        ],
      },
      {
        title: "Timescale limitations",
        href: "limitations",
        excerpt: "Current limitations of Timescale features",
      },
      {
        title: "Troubleshoot Timescale",
        href: "troubleshoot-timescaledb",
        excerpt: "Troubleshooting Timescale",
      },
      {
        title: "Compression (Old API, replaced by Hypercore)",
        href: "compression",
        children: [
          {
            title: "About compression",
            href: "about-compression",
            excerpt: "Learn about how compression works",
          },
          {
            title: "Compression design",
            href: "compression-design",
            excerpt: "The design of TimescaleDB compression",
          },
          {
            title: "About compression methods",
            href: "compression-methods",
            excerpt: "Learn about the different compression methods",
          },
          {
            title: "Enable a compression policy",
            href: "compression-policy",
            excerpt: "Create a compression policy on a hypertable",
          },
          {
            title: "Manual compression",
            href: "manual-compression",
            excerpt: "Compress data chunks",
          },
          {
            title: "Modify compressed data",
            href: "modify-compressed-data",
            excerpt: "Insert and modify data in compressed chunks",
          },
          {
            title: "Decompress chunks",
            href: "decompress-chunks",
            excerpt: "Decompress data chunks",
          },
          {
            title: "Modify a schema",
            href: "modify-a-schema",
            excerpt: "Change the data schema in compressed chunks",
          },
          {
            title: "Troubleshooting",
            href: "troubleshooting",
            type: "placeholder",
          },
        ],
      },
    ],
  },
];