> ## Documentation Index > Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # Quickstarts explorer > Explore quickstart guides to get up and running with ClickHouse export const QuickStartsGrid = ({quickStartsData = [], featured = []}) => { const featuredIds = featured.map(f => f.id); const data = quickStartsData || []; const assetBase = typeof window !== 'undefined' && window.location.pathname.startsWith('/docs') ? '/docs' : ''; const withBase = p => p && p.startsWith('/') ? assetBase + p : p; const readStoredList = (key, fallback) => { if (typeof window === 'undefined') return fallback; try { const raw = localStorage.getItem(key); if (!raw) return fallback; const parsed = JSON.parse(raw); return Array.isArray(parsed) ? parsed : fallback; } catch { return fallback; } }; const [searchTerm, setSearchTerm] = useState(() => { if (typeof window !== 'undefined') { return localStorage.getItem('quickstarts-search') || ''; } return ''; }); const [selectedUseCases, setSelectedUseCases] = useState(() => readStoredList('quickstarts-usecases', ['All'])); const [selectedProducts, setSelectedProducts] = useState(() => readStoredList('quickstarts-products', ['All'])); const [currentPage, setCurrentPage] = useState(1); const itemsPerPage = 6; const [showFilters, setShowFilters] = useState(() => { if (typeof window !== 'undefined') { return localStorage.getItem('quickstarts-show-filters') !== 'false'; } return true; }); const [isDesktop, setIsDesktop] = useState(true); useEffect(() => { if (typeof window === 'undefined' || !window.matchMedia) return; const mq = window.matchMedia('(min-width: 1024px)'); const update = () => setIsDesktop(mq.matches); update(); mq.addEventListener('change', update); return () => mq.removeEventListener('change', update); }, []); useEffect(() => { if (typeof window !== 'undefined') localStorage.setItem('quickstarts-search', searchTerm); }, [searchTerm]); useEffect(() => { if (typeof window !== 'undefined') localStorage.setItem('quickstarts-usecases', JSON.stringify(selectedUseCases)); }, [selectedUseCases]); useEffect(() => { if (typeof window !== 'undefined') localStorage.setItem('quickstarts-products', JSON.stringify(selectedProducts)); }, [selectedProducts]); useEffect(() => { if (typeof window !== 'undefined') localStorage.setItem('quickstarts-show-filters', String(showFilters)); }, [showFilters]); useEffect(() => { setCurrentPage(1); }, [searchTerm, selectedUseCases, selectedProducts]); const makeToggle = setter => value => { setter(prev => { if (value === 'All') return ['All']; const withoutAll = prev.filter(v => v !== 'All'); const result = withoutAll.includes(value) ? withoutAll.filter(v => v !== value) : [...withoutAll, value]; return result.length === 0 ? ['All'] : result; }); }; const toggleUseCase = makeToggle(setSelectedUseCases); const toggleProduct = makeToggle(setSelectedProducts); const useCaseOptions = ['All', 'Real-time analytics', 'Data warehousing', 'Observability', 'AI/ML']; const productOptions = ['All', 'Self-managed', 'Cloud', 'ClickPipes', 'Language clients', 'ClickStack', 'chDB']; const resetFilters = () => { setSearchTerm(''); setSelectedUseCases(['All']); setSelectedProducts(['All']); }; const hasActiveFilters = searchTerm !== '' || !selectedUseCases.includes('All') || !selectedProducts.includes('All'); const filteredQuickStarts = useMemo(() => { const term = searchTerm.toLowerCase(); return data.filter(quickStart => { if (featuredIds.includes(quickStart.id)) return false; const matchesSearch = term === '' || quickStart.title.toLowerCase().includes(term) || (quickStart.description || '').toLowerCase().includes(term); const useCases = quickStart.useCases || []; const matchesUseCases = selectedUseCases.includes('All') || useCases.length > 0 && useCases.every(uc => selectedUseCases.includes(uc)); const products = quickStart.products || []; const matchesProducts = selectedProducts.includes('All') || products.length > 0 && products.every(p => selectedProducts.includes(p)); return matchesSearch && matchesUseCases && matchesProducts; }); }, [data, searchTerm, selectedUseCases, selectedProducts, featuredIds]); const handleCardClick = (e, href) => { if (e.defaultPrevented) return; if (e.metaKey || e.ctrlKey || e.shiftKey || e.altKey || e.button !== 0) return; e.preventDefault(); window.location.assign(withBase(href)); }; const featuredQuickStarts = featured.map(f => { const qs = data.find(q => q.id === f.id); return { id: f.id, image: f.image, href: qs && qs.href || `/get-started/quickstarts/${f.id}`, title: qs && qs.title || '' }; }).filter(f => f.image); const FilterGroup = ({label, options, selectedOptions, onToggle}) => { const activeCount = selectedOptions.filter(o => o !== 'All').length; const displayLabel = activeCount > 0 ? `${label} (${activeCount})` : label; return
{displayLabel}
{options.map(option => )}
; }; return <>
{} {featuredQuickStarts.length > 0 &&

Featured quickstarts

{featuredQuickStarts.map(quickStart => handleCardClick(e, quickStart.href)} className="group block rounded-xl overflow-hidden border border-gray-200 dark:border-white/10 transition-all hover:border-black dark:hover:border-[#FAFF69] hover:shadow-md"> {}
)}
} {}
{}
{}
{}

Explore quickstarts

{filteredQuickStarts.length > 0 ? <> {} {(() => { const totalPages = Math.ceil(filteredQuickStarts.length / itemsPerPage); if (totalPages <= 1) return null; const hasPrev = currentPage > 1; const hasNext = currentPage < totalPages; return
Page {currentPage} / {totalPages}
; })()} :

No quickstarts found matching your criteria.

Try adjusting your filters or search term.

}
; }; export const featuredQuickstarts = [{ id: 'create-your-first-service-on-cloud', image: '/images/quickstarts/featured-quickstart-1.png' }, { id: 'insert-data-using-clickhouse-client', image: '/images/quickstarts/featured-quickstart-2.png' }, { id: 'obtain-your-cloud-connection-details', image: '/images/quickstarts/featured-quickstart-3.png' }]; export const quickStartsData = [{ id: 'connect-your-iceberg-catalog', title: 'How to connect your Iceberg catalog in ClickHouse Cloud', description: 'Learn how to connect ClickHouse Cloud to connect to your Data Catalog and query Iceberg tables.', href: '/get-started/quickstarts/connect-your-iceberg-catalog', useCases: ['Data warehousing'], products: ['Cloud'] }, { id: 'create-your-first-materialized-view', title: 'Create your first materialized view', description: 'Learn how to use materialized views in ClickHouse to pre-compute and store query results with a different sort order, enabling fast lookups on columns not covered by your primary key.', href: '/get-started/quickstarts/create-your-first-materialized-view', useCases: ['All'], products: ['Cloud', 'OSS'] }, { id: 'create-your-first-mergetree-table', title: 'Create your first MergeTree table', description: 'Learn how ClickHouses primary table engine works by creating a MergeTree table, loading UK property price data, and observing how parts and merges affect storage and query performance.', href: '/get-started/quickstarts/create-your-first-mergetree-table', useCases: ['All'], products: ['Cloud', 'OSS'] }, { id: 'create-your-first-projection', title: 'Create your first projection', description: 'Learn how to use projections in ClickHouse to store an additional sorted copy of your data within the same table, enabling fast lookups on columns not covered by your primary key.', href: '/get-started/quickstarts/create-your-first-projection', useCases: ['All'], products: ['Cloud', 'OSS'] }, { id: 'create-your-first-service-on-cloud', title: 'Create your first Cloud service and load example data', description: 'Create a ClickHouse Cloud service, explore the SQL console, and load an example dataset to start querying real data in minutes.', href: '/get-started/quickstarts/create-your-first-service-on-cloud', useCases: ['All'], products: ['Cloud'] }, { id: 'creating-tables', title: 'Creating tables in ClickHouse', description: 'Learn about Creating Tables in ClickHouse', href: '/get-started/quickstarts/creating-tables', useCases: [], products: [] }, { id: 'insert-data-using-clickhouse-client', title: 'Insert data into ClickHouse Cloud using clickhouse-client', description: 'Learn how to use clickhouse-client to insert data from local CSV and Parquet files into a ClickHouse Cloud service from the command line.', href: '/get-started/quickstarts/insert-data-using-clickhouse-client', useCases: ['All'], products: ['Cloud'] }, { id: 'mutations', title: 'Updating and deleting ClickHouse data', description: 'Describes how to perform update and delete operations in ClickHouse', href: '/get-started/quickstarts/mutations', useCases: [], products: [] }, { id: 'obtain-your-cloud-connection-details', title: 'Obtain your Cloud connection details', description: 'Learn how to find the hostname, port, and credentials for your ClickHouse Cloud service so you can connect from external clients, CLIs, and applications.', href: '/get-started/quickstarts/obtain-your-cloud-connection-details', useCases: ['All'], products: ['Cloud'] }, { id: 'tutorial', title: 'Advanced tutorial', description: 'Learn how to ingest and query data in ClickHouse using a New York City taxi example dataset.', href: '/get-started/quickstarts/tutorial', useCases: [], products: [] }, { id: 'working-with-the-map-type', title: 'Working with the Map type in ClickHouse', description: 'Learn how to use the Map type in ClickHouse to store, query, and aggregate dynamic key-value data using OTel resource attributes as a practical example.', href: '/get-started/quickstarts/working-with-the-map-type', useCases: ['Observability'], products: ['Cloud', 'OSS'] }, { id: 'writing-queries', title: 'Selecting ClickHouse Data', description: 'Learn about Selecting ClickHouse Data', href: '/get-started/quickstarts/writing-queries', useCases: [], products: [] }];
Decorative background image. Decorative background image.